Calculating the number of days between two dates

Excel 365 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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more