TODAY()

[alex]

Hello experts,

I've written a simple formula [=IF(F3<>"",TODAY(),"")] that populates
one cell with today's date when the referenced cell is not null.

The problem, however, is that once the date is entered I would like it
to stay static, i.e., not change. If I open the doc tomorrow, it will
display tomorrow's date.

Any advice to keep the date from changing once it's entered?

Thanks,
Alex

 

[Niek Otten]

Hi Alex,

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello experts,
|
| I've written a simple formula [=IF(F3<>"",TODAY(),"")] that populates
| one cell with today's date when the referenced cell is not null.
|
| The problem, however, is that once the date is entered I would like it
| to stay static, i.e., not change. If I open the doc tomorrow, it will
| display tomorrow's date.
|
| Any advice to keep the date from changing once it's entered?
|
| Thanks,
| Alex
|

 

[alex]

Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hello experts,
|
| I've written a simple formula [=IF(F3<>"",TODAY(),"")] that populates
| one cell with today's date when the referenced cell is not null.
|
| The problem, however, is that once the date is entered I would like it
| to stay static, i.e., not change. If I open the doc tomorrow, it will
| display tomorrow's date.
|
| Any advice to keep the date from changing once it's entered?
|
| Thanks,
| Alex
|

Thanks Niek for your response.

I've looked at the doc. I'm assuming that I need to check 'Iteration'
and write a circular reference (or do i need to write VBA).

=IF(A1="","",IF(B1="",NOW(),B1))

I don' t understand how that will keep the date static. Is it because
everytime Excel calculates the formula, in the case above, it will see
that B1 is not null (should A1 <> null, and keep the current value of
B1.

Why do i have to check the iteration box?

Alex