How the business days calculator works
A business day is any Monday to Friday that is not a public holiday. The calculator starts the day after your start date and counts every business day up to and including the end date, which is how "within 10 business days" deadlines are normally read. Adding business days works the same way: day 1 is the next business day after the start date.
US federal holidays are worked out from the rules in federal law (5 U.S.C. 6103) for any year. Australian state holidays come from each state government's official list, checked November 2026, and cover NSW, VIC, QLD, WA, SA, TAS, ACT, NT for 2026 and 2027 (most states also 2028).
Business days in each month of 2027
| Month | Weekdays | US federal business days |
|---|---|---|
| January 2027 | 21 | 19 |
| February 2027 | 20 | 19 |
| March 2027 | 23 | 23 |
| April 2027 | 22 | 22 |
| May 2027 | 21 | 20 |
| June 2027 | 22 | 21 |
| July 2027 | 22 | 21 |
| August 2027 | 22 | 22 |
| September 2027 | 22 | 21 |
| October 2027 | 21 | 20 |
| November 2027 | 22 | 20 |
| December 2027 | 23 | 21 |
| Total | 261 | 249 |
US federal holidays in 2027
- New Year's Day: Friday, January 1, 2027
- Martin Luther King Jr. Day: Monday, January 18, 2027
- Washington's Birthday (Presidents' Day): Monday, February 15, 2027
- Memorial Day: Monday, May 31, 2027
- Juneteenth: Friday, June 18, 2027
- Independence Day: Monday, July 5, 2027
- Labor Day: Monday, September 6, 2027
- Columbus Day: Monday, October 11, 2027
- Veterans Day: Thursday, November 11, 2027
- Thanksgiving Day: Thursday, November 25, 2027
- Christmas Day: Friday, December 24, 2027
- New Year's Day: Friday, December 31, 2027
Working days calculator for Australia
Choose your state in the "Public holidays to skip" list to count working days in Australia. Each state has its own holidays, such as Labour Day on different dates, the King's Birthday in June or October, and Melbourne Cup Day in Victoria. See the full lists: NSW public holidays, VIC public holidays, QLD public holidays, WA public holidays, SA public holidays, TAS public holidays, ACT public holidays, NT public holidays.
Frequently asked questions
How does the business days calculator count?
It counts every Monday to Friday after the start date up to and including the end date, and leaves out the public holidays you choose. So Monday to the next Monday is 5 business days. Tick "Count the start date" to include the first day as well.
Is a working days calculator the same as a business days calculator?
Yes. "Working days" is the usual term in Australia and the UK, "business days" in the US. Both mean weekdays that are not public holidays. Pick your state or the US federal holidays to match where you work.
Which holidays does it remove?
For the US, the 11 federal holidays on the weekday they are observed (a Saturday holiday moves to Friday, a Sunday holiday to Monday). For Australia, every statewide public holiday on your state government's official list, including substitute days. Part-day holidays (such as Christmas Eve from 7 pm in SA and NT) and regional holidays (such as the Ekka in Brisbane) are not removed.
How do I count business days in Excel?
Use =NETWORKDAYS(A1,B1,holidays), which counts both the start and end dates, or =NETWORKDAYS(A1,B1)-1 to match this calculator's default. =WORKDAY(A1,10,holidays) adds 10 business days to a date.
How many business days are in a year?
2027 has 261 weekdays. Taking out the US federal holidays observed in 2027 leaves 249 business days.
Sources: US federal holidays, 5 U.S.C. 6103 and the US Office of Personnel Management. Australian public holidays: NSW, VIC, QLD, WA, SA, TAS, ACT, NT. Last checked November 2026. How we calculate.