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
Hello,
I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to automatically update.
Thanks for any assistance,
I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to automatically update.
Thanks for any assistance,
Related:
- Insert the current date and time in cell a1
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Popcorn time download - Download - Movies, series and TV
- Lava a1 reset code ✓ - Phones, PDA & GPS Forum
- How to change date and time in whatsapp - Guide
- Lava gem - Phones, PDA & GPS Forum
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