Forum Discussion
TODAY() function
Currently I am running a call log to track sales leads. When I open the worksheet, I have one of the cells populated to automatically drop in the current date (say Cell C1) and there is an entry made in cell A1. If nothing is made in cell A1, then cell C1 stays blank. This way I can know what day I made the contact. However, the problem is that when I open the spreadsheet the next day, the dates from yesterday now read today's date. I am not sure how, or if, I can keep those dates from changing without going back and entering the previous day(s) date. If i do that, it defeats the purpose of making the Date cell dynamic/auto filled. Does my question make sense? Is it even doable?
Hi David,
If not using VBA known trick for timestamp is to use circular reference. See, for example, here http://www.howtoexcelatexcel.com/excel-tips-tricks/create-a-timestamp-in-excel-with-formulas/
If in brief
1) Enable iteractive iterations in Options->Formulas with maximum 1 iteration
2) Use formula
=IF(A1<>"", IF(COUNTBLANK(C1)>0, TODAY(), C1), "")I slightly modified initial example from blog above - using IF(COUNTBLANK(C1)>0,... is more reliable than IF(C1="",...
