Calculating the Number of Days between two dates

Excel 2016 2013 2007 2003
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 contains the open date and the close date for the account, you can calculate the number of days the account was open:

= C2 - B2

Number of days in Excel 2010

Excel will automatically format this formula cell as a date, rather than 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 July 1 and end the trip on Jily 9. Subtracting July 1 from July 9 produces an answer of eight days:

Number of days in Excel 2010

Actually, the trip lasted nine days:

= C2 - B2 + 1

Number of days in Excel 2010

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.