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

Closed
karudz Posts 1 Registration date Wednesday May 28, 2014 Status Member Last seen May 28, 2014 - May 28, 2014 at 08:45 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 30, 2014 at 02:02 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
May 30, 2014 at 02:02 AM
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.
0