date- keeping selected dates

Posted by steve on December 10, 2001 6:04 AM

I have a problem with the today formula. I would like to be able to populate a cell with today's date. The NOW or TODAY work fui=ine but when I open the sheet again on another day, the cells change. How can I keep the previous date value?

THanks

Posted by Tom Urtis on December 10, 2001 6:47 AM

Here is one way to "date stamp" today's date, if that is what you are looking for. Paste this into your Workbook_Open event or Auto_Open procedure.

If Sheets("Sheet1").Range("A1") = "" Then
Sheets("Sheet1").Range("A1").Value = Date
End If

HTH

Tom Urtis

Posted by steve.astrop on December 10, 2001 7:52 AM

Thanks Tom for the response. Not really what I'm after, yes I do need to "date stamp" certain cells but thats after I choose "yes" form a pull down. My previous formula was "if(a1="yes", today(), ""). This works, what I need is a way of keeping that value or to put it another way, after e value has been calculated it cant change.

Thanks again.

Posted by Mark W. on December 10, 2001 7:53 AM

You can use the keyboard shortcut Control+; to
enter the date into the active cell.

Posted by Mark W. on December 10, 2001 7:55 AM

Enter the current date (using Control+;) into a
cell (e.g., A1) then substitute A1 for TODAY() in
your formula.