retain date

[Trevor3007]

Hi,

I use the the code below:-
=IF(G2="y",TEXT(TODAY(),"dd/mm/yyyy"),"")

which work great until the next day, when yesterdays day is now the present day. Is there a way to retain the original date ?

Many thanks in advance.

KR
Trevor3007

 

[Trevor3007]

Hi Peter_SSs

Thanks for your help. Am all sorted now.
KR
Trevor3007

 

[Peter_SSs]

Hi Peter_SSs

Thanks for your help. Am all sorted now.
KR
Trevor3007

Good news. Thanks for the update.