View Single Post
 
Old 05-06-2016, 08:59 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

There are two methods of adding/subtracting dates.

1. 5/6/16-5/1/16=5
2. 5/6/16-5/1/16=6

The second example you include the last date in value, the first you do not. The spreadsheet returns '5', the internet calculator when told to include the last day returns '6'.
Reply With Quote