How to calculate the number of days between dates

In C5, I’ll add a start date.

The result is that we get a list of 14 consecutive dates.

Now let’s show the day of the week for each date.

There are several ways we can do this.

This time, I’ll set the format to only show the “day of week.”

In this case, we end up with just text.

Because dates are serial numbers in Excel, we can simply subtract the start date from the end date.

The result is 13.

What if you just want to count workdays, excluding weekends?

In that case, you’re free to use theNETWORKDAYS function.

In this first example, we’ll leave holidays out.

This gives us ten working days.

What if you want to exclude holidays?

For holidays, just snag the range that includes the holiday dates; the holiday names don’t matter.

Now we get a result of seven working days from December 20th through January 2nd.

If I remove one of the holidays in the list, the number increases by one.