View Single Post
 
Old 05-05-2016, 08:11 AM
markg2 markg2 is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default A basic date math/data view question

Start date, Today's date, Cumulative days between the two

To subtract Today from Start the date has to be reformatted to a number. Ordinary humans (me) find it difficult to readily grasp the #'s meaning.

So does that then entail double columns for each date--one formatted as a date to understand visually the date and the other as a number for the calculation?

Also, if I enter the keyboard shortcut for Today's date, save and then reopen the sheet the next day will said Today's date be automatically updated? But here's the clinker, that Today's date shortcut entered a visual date--I need a Today's date that the math will work with?

Mark
Reply With Quote