How to calculate days between dates in Excel

Days between dates calculator

If you are looking for a quick answer, this simple online calculator is at your service :)

Just enter the two dates in the corresponding cells, and the calculator will show you how many days there are from date to date.

Curious to know the formula that has calculated your dates? It's as simple as:

=B3-B2

Below you will find a detailed explanation of how this formula works and learn a few other methods to calculate days between dates in Excel.

How many days between dates calculation

The easiest way to calculate days between dates in Excel is by subtracting one date from another:

For example, to find out how many days are between dates in cells A2 and B2, you use this formula:

=B2 - A2

Where A2 is an earlier date, and B2 is a later date.

The result is an integer that represents no. of days between two dates:

Calculate number of days between dates in Excel with DATEDIF

Another way to count days between dates in Excel is by using the DATEDIF function, which is specially designed to work out the date difference in various units, including days, months and years.

To get the number of days between 2 dates, you supply the start date in the first argument, end date in the second argument, and "d" unit in the last argument:

In our example, the formula goes as follows:

=DATEDIF(A2, B2, "d")

Unlike the subtraction operation, a DATEDIF formula can only subtract an older date from a newer date, but not the other way round. If the start date is later than the end date, the formula throws a #NUM! error, like in row 5 in the screenshot below:

Count days between dates with Excel DAYS function

The users of Excel 2013 and Excel 2016 have one more amazingly simple way to calculate days between two dates - the DAYS function.

Please pay attention that compared to DATEDIF, a DAYS formula requires the arguments in the reverse order:

So, our formula takes the following shape:

=DAYS(B2, A2)

Like subtraction, it returns the difference as a positive or negative number, depending on whether the end date is greater or smaller than the start date:

How to calculate number of days between today and another date

In fact, calculating the number of days from or before a certain date is a particular case of "how many days between dates" math. For this, you can use any of the formulas discussed above and supply the TODAY function instead of one of the dates.

To calculate the number of days since date, i.e. between a past date and today:

To count the number of days until date, i.e. between a future date and today:

As an example, let's calculate the difference between today and an earlier date in A4:

=TODAY() - A4

And now, let's find out how many days are between today and a later date:

How to calculate working days between two dates in Excel

In situations when you need to get the number of days between two dates without weekends, use the NETWORKDAYS function:

The first two arguments should already look familiar to you, and the third (optional) argument allows excluding a custom list of holidays from the day count.

To find out how many working days are between two dates in columns A and B, use this formula:

=NETWORKDAYS(A2, B2)

Optionally, you can enter your holiday list in some cells and tell the formula to leave out those days:

=NETWORKDAYS(A2, B2, $A$9:$A$10)

As the result, only business days between two dates are counted:

Find number of days between two dates with Date & Time Wizard

As you see, Microsoft Excel provides a handful of different ways to count days between dates. If you are not sure which formula to use, let our Date & Time Wizard do the how-many-days-between-two-dates calculation for you. Here's how:

1. Select the cell in which you want to insert the formula.
2. On the Ablebits Tools tab, in the Date & Time group, click Date & Time Wizard:
   
3. In the Date & Time Wizard dialog window, switch to the Difference tab and do the following:
   • In the Date 1 box, enter the first date (start date) or a reference to the cell containing it.
   • In the Date 2 box, enter the second date (end date).
   • In the Difference in box, select D.

   The wizard immediately shows a formula preview in the cell and the result in the Difference in box.

4. Click the Insert formula button and have the formula inserted in the selected cell. Done!
   

A double-click on the fill handle, and the formula gets copied across the column:

To display the date difference in a slightly different way, you are free to choose any of the additional options:

• Show text labels - the word "days" will appear along with the number, like shown in the screenshot below.
• Do not show zero units­ - if the date difference is 0 days, an empty string (blank cell) will be returned.
• Negative result if Date 1 > Date 2 - the formula will return a negative number is the start date is later than the end date.

The screenshot below shows a couple of additional options in action:

This is how you calculate the number of days between dates in Excel. If you'd like to test our Date & Time Formula Wizard in your worksheets, you are welcome to download 14-day trial version of Ultimate Suite, which includes this as well as 70+ other time-saving tools for Excel.

Available downloads

How Many Days Between Dates - examples (.xlsx file)