Working days calculator
Business days between two dates, minus weekends and public holidays for your country or state.
Frequently asked questions
How do I calculate working days between two dates?
Choose your country or state, then a start and end date. The calculator counts Monday to Friday (Sunday to Thursday where the weekend is Friday and Saturday) and removes every public holiday in that list. Both the start and end dates are counted unless you untick the option.
Which holidays are excluded?
Full-day public holidays from our official holiday calendars, including substitute days. Part-day holidays (such as Christmas Eve evenings in parts of Australia) and holidays for one city only are not removed.
How do I add business days to a date, such as a 10-business-day deadline?
Use “Add working days”. The start date is not counted, so 10 working days from Sunday, November 15, 2026 in the United States is Monday, November 30, 2026.
What is the Excel formula for working days?
Use =NETWORKDAYS(start, end, holidays) for a Monday–Friday week, or =NETWORKDAYS.INTL(start, end, 7, holidays) for a Friday–Saturday weekend. To add working days, use =WORKDAY(start, days, holidays).
More date and time tools
- Days between dates Count days, weeks and months
- Date calculator Add or subtract days, months, years
- Hours calculator Hours between two times
- Time card calculator Weekly hours, overtime and pay
- Military time converter Military time to standard and back
- Week number What week of the year it is
- Day of the year Day number, days left, Julian date
- Unix timestamp converter Epoch to date and back
- Hours from now Clock time after X minutes or hours
- Days from now The date X days from today
- Days ago The date X days before today
- Time zone converter Convert a time between places
- Long-weekend planner Best days to take leave