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
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 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
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.
0
dbmich Posts 3 Registration date Monday March 9, 2015 Status Member Last seen March 12, 2015
Mar 11, 2015 at 08:56 AM
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
0
dbmich Posts 3 Registration date Monday March 9, 2015 Status Member Last seen March 12, 2015
Mar 12, 2015 at 01:43 PM
hello cmarzahn,
your recommendation worked. thank you very much.
kind regards,
dbmich
0