ExcelBanter - TODAY()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - TODAY() (https://www.excelbanter.com/excel-worksheet-functions/128578-today.html)

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

Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"alex" wrote in message ups.com...
| 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
|

On Jan 31, 8:13 am, "Niek Otten" wrote:
Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"alex" wrote in oglegroups.com...

| 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