Today() function to capture todays date and keep it like that the next day

**kaurka** · 03-26-2013, 04:08 PM

Hi,

I would like to find a way to keep todays date recorded and unchanged the next day. For example, if i enter "Closed" in a certain cell, i would like to record todays date via IF function or another way, and tomorrow when i reopen my worksheet, the date remains unchanged.

Thanks

**Ron Coderre** · 03-26-2013, 04:24 PM

Native Excel functions can't/don't actually write values to cells.

Perhaps this keyboard shortcut will help:

To insert the current date in a cell...Hold down CTRL and press ; <-that's a semicolon

Is that something you can work with?

**etaf** · 03-26-2013, 04:26 PM

use a timestamp with a change in the way a circular reference works - on the options

so if closed is entered in say A2
in B2
you would have
=IF(A2<>"",IF(B2="",NOW(),B2),"")

then you need to change the way circular references are setup

have a read here - good example
http://www.howtoexcelatexcel.com/exc...with-formulas/

**Ron Coderre** · 03-26-2013, 04:46 PM

Just be aware that ALL circular reference warnings in that workbook will be disabled.
Example:
A1: =SUM(A1:A5)
will not trigger the circular reference warning.