Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 675
- Office Version
- 365
- Platform
- Windows
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
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