Unvaried date as part of a formula
 

Basic idea: =IF(ISNUMBER(V10), DATE). This doesn't work, so how do I get
Excel to give me the current date in to this formula, but without updating
when I open the document in future?

Unvaried date as part of a formula
 

See this:

http://www.mcgimpsey.com/excel/timestamp.html

--
Biff
Microsoft Excel MVP


"EMW103" wrote in message
...
Basic idea: =IF(ISNUMBER(V10), DATE). This doesn't work, so how do I get
Excel to give me the current date in to this formula, but without updating
when I open the document in future?