Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enter Date if cell is not blank 2

Status
Not open for further replies.

shodadohs

Technical User
Dec 10, 2021
1
US
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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top