Katamelns

Insert current time Control Shift To enter both in both values in a single cell, enter the date, a space, then the time Formatting results The result of TODAY is a serial number representing a valid Excel date You can format the value returned by TODAY using any standard date format Your code ActiveCellFormulaR1C1 = "=NOW ()" is absolutely perfect It works correctly on my System You not need to till tomorrow to check the output of this code, first write this code and run macro and save and close it (please check the date) After closing the file change your system date ie suppose today is 13Mar then set the 14MarIf you are not familiar with VBA code, you also can apply the Find and Replace utility to jump to the current date 1 Enable the sheet which contains the date list, and select a blank cell, type this formula =TODAY (), press Enter key, now you get the today date 2 How To Update Or Insert Current Date And Time By A Command Button In Excel Excel code for today's date