Automatically insert the current date into one cell when "x" is

[Closed]
Report
Posts
1
Registration date
Wednesday May 28, 2014
Status
Member
Last seen
May 28, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I'm trying to create and IF formula. What I want it to do it automatically insert the current date into one cell when "x" is typed into a different cell. If it could also insert the time into another cell that would be ideal. Is there any way to do this?! Maybe I can use a different formula instead of an IF formula?? Any ideas?! Thanks!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose A1 has x (or not having x) in B1 use this formula
B1 can be copied down


=IF(A1="x",NOW(),"")

format B1 as date and time suitable to you.