How to use it
- Choose Between two dates or Add business days.
- Pick the dates (or the start date and the number of days) and the holidays to skip.
- Read the business days, calendar days and the holidays that were skipped.
Questions and answers
Is the start date counted?
By default the count starts the day after the start date and includes the end date, like most deadlines. Tick “Count the start date” to include it.
Which holidays are skipped?
The 11 US federal holidays. When one falls on a Saturday it is observed on Friday, and on a Sunday it is observed on Monday, so that weekday is skipped.
How many business days are in 2026?
The table below shows the business days of each month of the year with US federal holidays; most months have 20 to 23.
How do I count business days in Excel?
Use =NETWORKDAYS(start, end, holidays) to count and =WORKDAY(start, days, holidays) to add. NETWORKDAYS counts both the start and the end date.