Add-ins.com home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week
     

Quantity
Discounts

Money back
guarantee

Subtracting Dates

If you enter two dates in cells in a worksheet and then subtract them, the result is typically like this (american format, month/day.year):

   or  

The first shows the difference in days between the two days.  The second has had the difference accidently formatted as a date.

Excel stores dates as the number of days from the start of 1900.  So, May 3, 2014 is 41762 and Jan 1, 1988 is 32143. The difference is 9619.

To get the difference to look like the following,

right click on the date difference cell and select Format Cells, Number Tab, Custom Category and enter: y "years" m "months" d "days"

Return to the tips home page


Copyright 2017 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.