TodayFree forever - no sign-up, no paid plans

How to add business days in Excel with WORKDAY

By Daniel Mercer · Updated November 3, 2026

Open the Date Calculator

Plain addition adds calendar days, weekends included. Business promises do not work that way - "delivery in 10 business days" skips Saturdays, Sundays and usually holidays too. Excel's WORKDAY function does that count natively. This guide shows the basic formula, the holiday list that makes it trustworthy, and the INTL variant for weekends that are not Saturday and Sunday.

The basic formula

=WORKDAY(start_date, days) returns the date that many business days after the start date. Two details define its behaviour: the start date itself is never counted, and Saturdays and Sundays are always skipped. So =WORKDAY(DATE(2026,11,20),10) - ten business days after Friday, November 20, 2026 - counts November 23, 24, 25, 26 and 27 as the first five, November 30 to December 4 as the second five, and returns Friday, December 4, 2026. The same job away from a spreadsheet is what our date calculator and the dedicated business days tool are for, but inside a workbook WORKDAY is the right instrument.

How to add business days in Excel with WORKDAY - a gavel beside court deadline papers

Adding the holiday list - the step that makes it honest

WORKDAY on its own skips only weekends. Real business-day promises almost always skip public holidays too, and the third argument is where they go: =WORKDAY(A1,10,$H$2:$H$12) reads its holidays from a list you maintain in the workbook. Watch what one holiday does to the example above. Put Thanksgiving - Thursday, November 26, 2026 - in the list, and the count changes: the first week now contributes only 4 business days (November 23, 24, 25 and 27), so the tenth business day slides to Monday, December 7, 2026. One holiday, one working day later. A deadline spreadsheet without a holiday list is quietly optimistic everywhere, which is why the list deserves its own corner of the workbook, kept current year by year.

Two list-keeping rules matter. The holidays must be real Excel dates, not text that looks like dates, or the function ignores them without warning. And lock the range with dollar signs, as in the formula above, so the reference does not drift when the formula is filled down a column of orders.

Counting backward, and counting between

A negative number of days runs WORKDAY in reverse: =WORKDAY(A1,-10) gives the date 10 business days before the start, which is how you find the latest safe start for a fixed deadline - the mirror of the forward problem in our guide on working out a deadline date from a start date. The companion function NETWORKDAYS answers the opposite question - how many business days sit between two dates you already have: =NETWORKDAYS(A1,B1,holidays). One caution: NETWORKDAYS counts both the start and end dates when they are business days, while WORKDAY never counts its start date. Mixing the two conventions in one workbook is a classic source of one-day disagreements, so note which one each formula uses.

WORKDAY.INTL - when the weekend is not Saturday and Sunday

WORKDAY hard-codes the Saturday-Sunday weekend. WORKDAY.INTL adds a weekend argument: a number code for common patterns, or a seven-character string where each position is a weekday from Monday to Sunday, with 1 meaning "weekend" and 0 meaning "working day". The string for a Friday-Saturday weekend is "0000110". With that weekend, =WORKDAY.INTL(DATE(2026,11,22),5,"0000110") counts Monday 23, Tuesday 24, Wednesday 25, Thursday 26 and Sunday 29, returning Sunday, November 29, 2026 - because Friday and Saturday were the days off. If you work with suppliers or offices in regions with a different working week, INTL is not a refinement; it is the difference between a right answer and a plausible wrong one. The days between calculator on our homepage likewise shows business days with US federal holidays removed, so you can cross-check a workbook figure against an independent count.

The companion function - NETWORKDAYS counts the other way

WORKDAY answers "what date is N business days from here?" Its companion NETWORKDAYS answers the reverse question: "how many business days sit between these two dates?" The syntax mirrors the same logic - =NETWORKDAYS(start, end, holidays) - and it counts both endpoint days when they are business days, which makes it the right tool for checking a span rather than building one. Payroll teams pair the two constantly: NETWORKDAYS to count the working days in a period someone actually worked, WORKDAY to project the date a notice period or a processing window ends. One caution when you combine them: because NETWORKDAYS includes both ends and WORKDAY excludes the start, running one and then the other does not always return you to the exact date you began with. That is not a bug - it is the inclusive-versus-exclusive counting difference from our guide to counting forward versus counting backward, surfacing inside a spreadsheet.

Finally, keep your holiday list alive. A Holidays sheet built for 2026 quietly becomes wrong in 2027 - Thanksgiving moves, observed days shift when holidays land on weekends, and one-off closures never make the list at all. Rebuild the range each January, and name it clearly, so every WORKDAY formula on the workbook inherits the correction at once.

Test your formula before you trust it

Before a WORKDAY formula goes anywhere near a real deadline, run it on a pair of dates you can check by hand. Use the example from this page: =WORKDAY(DATE(2026,11,20),10) must return December 4, 2026, and adding the Thanksgiving holiday to the list must move it to December 7, 2026. If your formula returns either date correctly, the weekend rule, the start-day exclusion and the holiday range are all wired up properly. If it returns December 4 even with the holiday included, the holidays argument is not being read - the single most common WORKDAY fault, and far better caught on a test than on a filing date.

Frequently asked questions

How does the WORKDAY function work in Excel?

=WORKDAY(start_date, days) returns the date that many business days after the start date, skipping Saturdays and Sundays. The start date itself is not counted. =WORKDAY(DATE(2026,11,20),10) returns December 4, 2026 - ten business days after Friday, November 20.

How do I make WORKDAY skip holidays as well?

Add a third argument pointing at a range of holiday dates: =WORKDAY(A1,10,$H$2:$H$12). Any holiday that falls on a weekday is skipped as well. With Thanksgiving, November 26, 2026 in the list, the same 10 business days from November 20 end on December 7 instead of December 4.

Can WORKDAY count backward?

Yes. Use a negative number of days: =WORKDAY(A1,-10) returns the date 10 business days before the start date. This is the standard way to find the latest start date for a fixed deadline.

What is the difference between WORKDAY and WORKDAY.INTL?

WORKDAY always treats Saturday and Sunday as the weekend. WORKDAY.INTL adds a weekend argument so you can define other weekends, such as Friday and Saturday, or a single day. It matters for teams and suppliers in regions where the working week differs.

How do I count business days between two dates instead of adding them?

Use NETWORKDAYS: =NETWORKDAYS(start_date, end_date, holidays) returns how many business days fall between the two dates, counting both the start and end dates if they are business days. NETWORKDAYS.INTL does the same with a custom weekend.

Related guides

How to add days in Excel - simple formulas and EDATE

Calendar-day addition and month arithmetic in Excel.

How to add days to a date in Google Sheets

WORKDAY and friends in Sheets, with its own traps.

How to work out a deadline date from a start date

The deadline rules WORKDAY automates, worked by hand.

Adding months to a date - the month-end problem

Why month arithmetic needs EDATE, not addition.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.