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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 30, 2014 at 02:02 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 30, 2014 at 02:02 AM
Related:
- Insert the current date and time in cell a1
- Trying to have the current date go into one cell (A1) ✓ - Excel Forum
- Popcorn time - Download - Movies, series and TV
- Lava a1 reset code ✓ - Phones, PDA & GPS Forum
- Lava A1 Brand reset ✓ - Phones, PDA & GPS Forum
- Lava gem - Phones, PDA & GPS Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 30, 2014 at 02:02 AM
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.
B1 can be copied down
=IF(A1="x",NOW(),"")
format B1 as date and time suitable to you.
