Enter Date if cell is not blank 2

[shodadohs]

I got help from someone at work to help me get this working properly
Just wanted to share for anyone else who needs this.
I've searched on google how to do this but the only one I found used visual basic.

For security reasons our IT Specialist told me not to use that version (Macro Enabled)
Our IT Specialist after multiple tries was able to come up with this method.

I am using office 365 by the way.

First, go to File, Options, Formulas, then Enable iterative calculation
This will not work unless that box is checked

Make sure the Date column is formatted to display dates

Here is the template:

=IF(CellYouWantToCheck<>"",IF(CellWithDate<>"",CellWithDate,NOW()),"")

Just note that if you open this file on a different computer than the one you made the file on, you will need to make sure you enable iterative calculation for it to display correctly
Hope this helps someone else!

 

[byundt]

Did you know there is a keyboard shortcut to enter today's date in a cell? The date will be entered as a static value, so need to turn iterative calculation on. Neither is there a need to format the cell as Date, because the shortcut does it for you.

CTRL + ; shortcut for date
CTRL + : shortcut for time