Formula help - If (a specific cell) contains any values, then give me the current date.
My excel spreadsheet is attached.
In the date column, I want it to look at the order number column, and, once an order number is typed in, I want the date column to automatically show the current date. So for every order number typed in, it will show the date that this happened.
I know that =TODAY would change the date every day that passes and this would be inaccurate.
Hope this makes sense, please help
Thanks in advanceAutomotive Order Number Template - V2016 - Month - various tabs.xlsx
Only by macro with Worksheet Event Change
Lets say Date Column is A and the Order Column is B
Please Login or Register to view this content.
There are a couple of ways to do this. Here's a simple formula-based approach. I had to remove the data validation in column N. If you want the date to update automatically, you won't need it... To get this to work; you need to enable iterative calculatios.
FILE/OPTIONS/FORMULAS/Enable iterative calculations. I've already done that. In N9, copy down:
=IF(M9="ENTER CENTRE","",IF(N9="",NOW(),N9))
Do whatever you need to do to change any cell in column M9 doe=wnawards to anything other than ENTER CENTRE. This will put a non-updating date in the corresponding cell in column N. if you don't want to have to wait till tomorrow; format N as time and check it out...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks