Trying to have the current date go into one cell (A1)
Solved/Closed
dbmich
Posts
3
Registration date
Monday March 9, 2015
Status
Member
Last seen
March 12, 2015
-
Mar 10, 2015 at 08:57 AM
dbmich Posts 3 Registration date Monday March 9, 2015 Status Member Last seen March 12, 2015 - Mar 12, 2015 at 01:43 PM
dbmich Posts 3 Registration date Monday March 9, 2015 Status Member Last seen March 12, 2015 - Mar 12, 2015 at 01:43 PM
Related:
- Insert the current date and time in cell a1
- Popcorn time download - Download - Movies, series and TV
- Lava a1 reset code ✓ - Phones, PDA & GPS Forum
- Lava A1 Brand reset ✓ - Phones, PDA & GPS Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- How to change whatsapp date and time - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 10, 2015 at 10:32 PM
Mar 10, 2015 at 10:32 PM
You might try this...
=IF(B1<>"",IF(A1="",NOW(),A1),"")
It will only put a date, if you enter a value in B1.
It is intentionally written as a circular reference so you will need to enable iterative calculations under File Option Formulas.
It will remain as long as a value remains in B1. If B1 is erased the date will go back to null (empty) and will automatically update when that empty cell has new data in it... You can change the data but and it will remain the same as long as it is not erased...
Hope that helps.
=IF(B1<>"",IF(A1="",NOW(),A1),"")
It will only put a date, if you enter a value in B1.
It is intentionally written as a circular reference so you will need to enable iterative calculations under File Option Formulas.
It will remain as long as a value remains in B1. If B1 is erased the date will go back to null (empty) and will automatically update when that empty cell has new data in it... You can change the data but and it will remain the same as long as it is not erased...
Hope that helps.
Mar 11, 2015 at 08:56 AM
thank you for your timely response. I just put the formula into my worksheet and ill see if today's date holds in the worksheet when I open it tmrw. keep you posted.
kind regards,
dbmich
Mar 12, 2015 at 01:43 PM
your recommendation worked. thank you very much.
kind regards,
dbmich