TODAY function

  • Thread starter Thread starter atom
  • Start date Start date
A

atom

Using this formula...

=IF(B44<>"", (TODAY()), "")

....the result is today's date, if B44 isn't blank. How can I get the
date to stay at the day it was entered, instead of changing with my
computer's clock?

thanks
 
One way

=IF(B44="","",IF(C44="",TODAY(),C44))

then do tools>options>calculations and turn on iteration

Note that I used C44, replace C44 with the cell address where
you want this done, i.e. if you put the formula in A1 replace C44 with A1.
This creates a circular reference error if you don't turn on iteration
 
Thanks, worked perfectly.

Peo said:
One way

=IF(B44="","",IF(C44="",TODAY(),C44))

then do tools>options>calculations and turn on iteration

Note that I used C44, replace C44 with the cell address where
you want this done, i.e. if you put the formula in A1 replace C44 with A1.
This creates a circular reference error if you don't turn on iteration

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top