Skip to content
OfficeOpenToday

Days between dates

Days between dates is the number of whole midnights from a start date to an end date. Working days count weekdays minus observed US federal holidays, matching Excel NETWORKDAYS. Reverse the dates and the counts stay the same.

How many days between two dates

Date range

Quick picks

Working days = weekdays minus observed US federal holidays. Calendar days are midnights between the dates.

Compare

File

Name From To Days
30
Weekday tally in the primary range
SunMonTueWedThuFriSat
4455544

Count days

1 federal holiday in the default range.

Need only NETWORKDAYS? Working days calculator.

Days between dates FAQ

Is the range inclusive?

Working days count both endpoints, matching Excel NETWORKDAYS. Calendar days are whole midnights between the two dates. Turn on inclusive dates to count every calendar date in the span, which is one more than that midnight count.

Which holidays are excluded from working days?

US federal holidays on their observed dates, across the published year window. State holidays are not removed. The list expands when your range includes a holiday.

What if I reverse the dates?

Counts stay the same. Swap dates with one click — direction only changes the signed calendar-day readout.

Can I compare more than one range?

Yes. Add this range to the sheet, or add a blank range. Save, CSV, and print need scripting; today through 30 days out stays in the HTML.