How to Count Working Days in Excel?
Count Business Days Between Dates is a Excel function that calculates the number of working days between two specified dates, excluding weekends and any holidays listed.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Counting business days between two dates can be tricky, especially with holidays. Use the NETWORKDAYS function to simplify this task.
The Formula
"Count the number of working days between two dates, excluding weekends and a list of holidays"
=NETWORKDAYS(start_date, end_date, [holidays])This formula calculates the number of working days between two specified dates, excluding weekends and any holidays listed.
Step-by-Step Breakdown
- Step 1: Specify the start date from which to begin counting.
- Step 2: Specify the end date up to which to count the working days.
- Step 3: Optionally, provide a range of holiday dates to exclude from the count.
- Step 4: The formula returns the total number of weekdays between the two dates, minus any holidays.
Edge Cases & Warnings
- If the start date is after the end date, the result will be zero.
- If all days between the dates are holidays, the result will also be zero.
- If the start date and end date are the same and it's a weekday, the result will be one.
- If the holidays include weekends, they will not affect the count.
Examples
"Start: 2023-10-01, End: 2023-10-10, Holidays: 2023-10-05"
6"Start: 2023-11-01, End: 2023-11-30, Holidays: 2023-11-25"
20Frequently Asked Questions
What if my start date is a holiday?
The formula will count from the next working day.
Can I use this formula for future dates?
Yes, it works for any valid date range.
What happens if there are no holidays?
The formula will count all weekdays between the two dates.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.