View Single Post
 
Old 03-07-2018, 02:32 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Excel uses a 5 digit number to represent dates so that it can do calculations...

today's date, for instance is represented as 43166. (to see this enter today's date in a cell, then format it as General).

Now 43166-0 = 43166 and 43166+1 = 43167 which when multiplied by 10 gives 431670..... so there should be a date of some kind in column K.
Reply With Quote