# Calculating the Number of Days between two dates

A common type of date calculation determines the number of days between two dates.

For example, you may have a financial worksheet that calculates interest earned on a deposit account. If you sheet containes the open date and the close date for the account, you can calculate the number of days the account was open:

=C2-B2

Excel will automatically format this formula cell as a date, rather then a numeric value. Therefore, your will need to change the number format so the result is displayed as a non-date. If cell B2 contains a more recent date than the date in cell C2, the result will be negative.

Sometimes, calculating the difference between two days is more difficult. For example, you start a trip on September 1 and end the trip on September 17. Substracting September 1 from September 17 produces an answer of 16 days:

Actually, the trip lasted 17 days:

=C2-B2+1

Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source article

http://www.officetooltips.com/excel 2016/tips/calculating the number of days between two dates.html