How to count days between two dates including start date in Excel?
In Excel, we can calculate days between two dates by using a simple formula: =End date –Start date, but, this formula will exclude the start date. If you need to count days between two dates including the start date, this article will help you.
Recommended Productivity Tools for Excel/Office
The following formulas can help you to solve this task as you need, please do as follows:
Enter any one of the following formulas into a blank cell where you want to get the result:
And then drag the fill handle down to the cells where you want to apply this formula, and all the days between two given dates have been calculated, see screenshot:
Note: In the above formulas, B2 is the end date and A2 is the start date cell, you can change them to you need.
Recommended Productivity Tools
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
300 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...