Trying to have the current date go into one cell (A1)
Solved/Closed
dbmich
Posts
3
Registration date
Monday 9 March 2015
Status
Member
Last seen
12 March 2015
-
10 Mar 2015 à 08:57
dbmich Posts 3 Registration date Monday 9 March 2015 Status Member Last seen 12 March 2015 - 12 Mar 2015 à 13:43
dbmich Posts 3 Registration date Monday 9 March 2015 Status Member Last seen 12 March 2015 - 12 Mar 2015 à 13:43
Related:
- Insert the current date and time in cell a1
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Lava a1 reset code ✓ - Phones, PDA & GPS Forum
- Lava A1 Brand reset ✓ - Phones, PDA & GPS Forum
- How to format Lava mobile? ✓ - Phones, PDA & GPS Forum
- Where is the insert key - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
10 Mar 2015 à 22:32
10 Mar 2015 à 22:32
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.
11 Mar 2015 à 08:56
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
12 Mar 2015 à 13:43
your recommendation worked. thank you very much.
kind regards,
dbmich