Richard,

As it happens, the date does change each day. Thus NOW() returns the current date. If you
want something to look at those cells and plop in a fixed date, it'll take a macro.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Richard" wrote in message
...
I'm having a problem trying to get this formula to work
=IF(C4=0,NOW(),IF(C40,"",IF(E4="",NOW(),E4))). The date keeps changing each
day. Is formula works fine =IF(B3="","",IF(C3="",NOW(),C3)).
Tools/options/calculations/Iterations. Can anyone please help me with the
first formula. Thanks in advance!