See this:

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

--
Biff
Microsoft Excel MVP


"jknapp1005" wrote in message
...
I'm trying to get a date function to return. If I put in NOW or TODAY it
returns a date of a passed or failed unit, but when I close the sheet out
and
reopen, it refreshes the date. I need what's returned to remain the date
of
the event. Formula I'm using is:

=IF(C101="PASS",TODAY( ))