Dates & Calendars

How to Count Business Days in Excel and Google Sheets (NETWORKDAYS and WORKDAY)

Count working days between two dates with NETWORKDAYS, add business days with WORKDAY, skip holidays, and handle custom weekends with the .INTL versions.

How to Count Business Days in Excel and Google Sheets (NETWORKDAYS and WORKDAY)
In this article
  1. Check your answer
  2. Calculate NETWORKDAYS in Excel: working days between two dates
  3. WORKDAY: a date a number of working days away
  4. Different weekends: the .INTL versions
  5. Common questions and pitfalls
  6. Practical examples
  7. Keeping a holiday list that updates itself
  8. Counting a particular weekday
  9. Example: a Friday–Saturday weekend
  10. Working days left in the month, quarter or year
  11. Business days in other tools
  12. Frequently asked questions
  13. Sources

To count working days between two dates in Excel or Google Sheets, use =NETWORKDAYS(start, end, holidays). To find the date a number of working days after a start date, use =WORKDAY(start, days, holidays). Both skip Saturdays and Sundays automatically and any dates you list as holidays. For other weekend patterns, use NETWORKDAYS.INTL and WORKDAY.INTL.

Check your answer

The calculator below uses the same rules as NETWORKDAYS (both dates counted) and WORKDAY (start date is day 0), so you can test a formula before rolling it out.

Loading the calculator…

Calculate NETWORKDAYS in Excel: working days between two dates

=NETWORKDAYS(A2, B2)

With a start date in A2 and an end date in B2, NETWORKDAYS Excel returns the number of Mondays to Fridays from A2 to B2, counting both dates. From Monday 19 October 2026 to Friday 23 October 2026, the result is 5.

NETWORKDAYS excel: A pen, planner, coffee cup, and glasses on a spreadsheet with numbers.

To skip public holidays, list them in a range (say E2:E12) and add it as the third argument:

=NETWORKDAYS(A2, B2, $E$2:$E$12)

Holidays that fall on a weekend are ignored, so you can paste a full official list without editing it. Use dollar signs so the range stays fixed when you copy the formula down.

WORKDAY: a date a number of working days away

=WORKDAY(A2, 10, $E$2:$E$12)

This returns a date 10 working days after A2. The start date isn’t counted; one working day after Friday is Monday. Use a negative number to go back. For example, =WORKDAY(A2,-5) is five WORKDAYs before a deadline. Format the result cell as a date. Otherwise, Excel shows a serial number, like 46317, for the NETWORKDAYS Excel function.

An ancient stone calendar surrounded by lush green foliage and rocks.

Different weekends: the .INTL versions

Not everyone works Monday to Friday. NETWORKDAYS.INTL and WORKDAY.INTL take a weekend argument:

Wooden dolls representing different cultures holding hands in front of a globe.
Weekend Code Example formula
Saturday–Sunday 1 =NETWORKDAYS.INTL(A2,B2,1)
Friday–Saturday 7 =NETWORKDAYS.INTL(A2,B2,7)
Sunday only 11 =NETWORKDAYS.INTL(A2,B2,11)
Friday only 16 =NETWORKDAYS.INTL(A2,B2,16)
Custom pattern “0000011” 7 characters, Monday first; 1 = day off

The text pattern is the most flexible: "0000110" means Friday and Saturday off, and "0000001" a six-day week with only Sunday off.

Common questions and pitfalls

Why is my count one day more than expected?

NETWORKDAYS includes both the start and the end date. If your rule excludes the start date (“10 working days from receipt”), subtract 1, or use WORKDAY to find the end date instead.

A man thinking with question marks and an equation in the background.

Why do I get #VALUE!?

One of the dates is text rather than a real date. Check with =ISNUMBER(A2), and type dates in ISO format (2026-10-23) to avoid day/month confusion.

What about half days?

Neither function handles half days. Count them separately and subtract 0.5 for each.

Does Google Sheets work the same?

Yes. NETWORKDAYS, WORKDAY and both .INTL versions exist in Google Sheets with the same arguments and results.

Practical examples

  • Days of leave taken: =NETWORKDAYS(first_day, last_day, holidays).
  • Invoice due in 30 working days: =WORKDAY(invoice_date, 30, holidays).
  • Working days left this month: =NETWORKDAYS(TODAY(), EOMONTH(TODAY(),0), holidays).
  • Working days in a year: =NETWORKDAYS(DATE(2027,1,1), DATE(2027,12,31), holidays) — 261 before holidays.

For context on yearly totals, see how many working days are in a year.

Keeping a holiday list that updates itself

Put your holidays on a separate sheet in one column, select it and give it a name — Formulas → Define Name → Holidays. Your formulas then read =NETWORKDAYS(A2,B2,Holidays). When next year’s holidays are added at the bottom, update the named range (or format the list as an Excel Table so the name grows automatically). Every formula in the workbook picks up the change.

Person working on a laptop with a calculator and tablet nearby.

Include substitute days: When Christmas Day falls on a Saturday, the UK bank holiday moves to the following Monday or Tuesday. US federal holidays on a Saturday are observed on the Friday before. This is important for NETWORKDAYS calculations in Excel.

Counting a particular weekday

NETWORKDAYS.INTL can count single weekday occurrences. For example, count Mondays between dates for class planning. Mark every day except Monday as a “weekend” using the pattern "0111111" in networkdays excel.

=NETWORKDAYS.INTL(A2,B2,"0111111")

Change the position of the 0 for other weekdays: "1111011" counts Fridays.

Example: a Friday–Saturday weekend

In countries where the weekend is Friday and Saturday, a 20-working-day deadline from Sunday 1 November 2026 is:

=WORKDAY.INTL(DATE(2026,11,1),20,7,Holidays)

Weekend code 7 skips Fridays and Saturdays, so the count runs Sunday to Thursday.

Working days left in the month, quarter or year

You want Formula
Working days left this month (including today) =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0),Holidays)
Working days left this year =NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),12,31),Holidays)
Working days in next month =NETWORKDAYS(EOMONTH(TODAY(),0)+1,EOMONTH(TODAY(),1),Holidays)
Is a date a working day? =NETWORKDAYS(A2,A2,Holidays)=1

Business days in other tools

  • Python (NumPy): numpy.busday_count('2026-10-19','2026-10-26') returns 5 — note the end date is excluded, unlike NETWORKDAYS.
  • SQL: most databases need a calendar table with a working-day flag; join to it and count.
  • No code: the business days calculator on this site, with your own holiday list.

Frequently asked questions

What does NETWORKDAYS do?

It counts the weekdays between two dates, including both dates, minus any holidays you list.

What is the difference between NETWORKDAYS and WORKDAY?

NETWORKDAYS returns a number of days; WORKDAY returns a date a number of working days away.

How do I exclude holidays?

Put the holiday dates in a range and pass it as the last argument.

Can I use a Friday–Saturday weekend?

Yes, with NETWORKDAYS.INTL or WORKDAY.INTL and weekend code 7.

Sources

Photo of Yasir Hafeez

Written by

Yasir Hafeez is the founder and editor of ItsAgeCalculator. He builds the calculators, writes and checks the guides and articles, and tests every result against fixed date rules. He also runs OmniMatrics, a site of everyday calculators and converters.

More articles · Editorial policy · Spotted a mistake? Let us know.

Age tools