Excel Static Date

[raajnabriz]

Dear Sir,

[FONT=open_sansregular]I am trying to format a date cell to return todays date if a cell in the same row is marked "Received" using the IF formula.

[/FONT]=IF(F1 = "RECEIVED", TODAY(),"")

[FONT=open_sansregular]But the issue in the above formula is when I open the file the next day the date changes, I want the date to be static, how to get that. Any ideas?

Thanks,
Raaj.
[/FONT]

 

[tyija1995]

Hey Raaj,

You would have to copy the cell and paste it as values after it picks up today's date, then when you open the file tomorrow it will display yesterdays date.

 

[raajnabriz]

Sadly, I am doing just that all these years, but thought there might be something new around.

Hope someone comes along with a new idea.

Thanks,
Raaj.

 

[sandy666]

maybe adapt this:

B2: =IF(A2="","",IF(B2="",NOW(),B2))

Iterative calculation must be enabled