Forum Discussion

Copper Contributor

Apr 07, 2017

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 mad...

Formulas & Functions

tips and tricks

SergeiBaklan

Diamond Contributor

Apr 08, 2017

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="",...