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