Static Date

[philrobbo]

I have a work sheet that collects data that I enter in progressive order. I need to record the date and time that each entry was entered.

Unfortunately, using the formula below it recalcs every time I reopen the sheet.

How can I make it static.

=IF(C7<=0,"",TODAY())

Phil

 

[mole999]

NOW() will give Date and Time. Usually it would be done in VBA code and saved as a one of value