Thread: TODAY()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alex alex is offline
external usenet poster
 
Posts: 48
Default TODAY()

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