Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Count days between two dates including start date with formulas


arrow blue right bubble Count days between two dates including start date with formulas

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:

=IF(OR(B2="",A2=""),"",INT(B2-A2+1))

=IF(NOT(OR(ISBLANK(B2),ISBLANK(A2))),B2-A2+1,"")

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:

doc count days inclusive 1

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

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 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...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.