Strictly speaking the date stamp in Excel is done by pressing Ctrl + ; however if you would like to place a date stamp automatically when data is entered into a specific cell the i find that the following formula works well.
=NOW()
This will place the current date and time e.g. 15/08/2008 13:57. The down side is that every time the sheet recalculates i.e. any time enter or return is pressed the date stamp is updated. The easiest way around this is to create a circular statement. For example if when data is entered in to cell A1 you want to place a date stamp in B1 then the following formula will work.
=IF(A1="","",IF(B1="",NOW(),B1))
However due to the circular reference which basically stop the cell recalculating an error will be returned. To stop this go to Tools>Option select the Calculation tab and tick the Iterations box. This will solve the circular reference problem.
No comments:
Post a Comment