Trying to have the current date go into one cell (A1)

Solved/Closed
Report
Posts
4
Registration date
Monday March 9, 2015
Status
Member
Last seen
March 12, 2015
-
Posts
4
Registration date
Monday March 9, 2015
Status
Member
Last seen
March 12, 2015
-
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,


1 reply

Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
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.
Posts
4
Registration date
Monday March 9, 2015
Status
Member
Last seen
March 12, 2015

hello cmarzahn,
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
Posts
4
Registration date
Monday March 9, 2015
Status
Member
Last seen
March 12, 2015

hello cmarzahn,
your recommendation worked. thank you very much.
kind regards,
dbmich