Add business days with WORKDAY
WORKDAY returns the date that is a given number of working days before or after a start date, skipping Saturdays, Sundays and any holidays you list.
=WORKDAY(A2,10,Holidays!$A$2:$A$20)The sheet: Column A is an invoice date. Payment is due 10 business days later, skipping weekends and the holiday dates listed on a Holidays tab.
How it works, step by step
- 01A2 is the start date. It is not counted as one of the 10 days.
- 0210 is the number of working days to move forward. A negative number moves back.
- 03Holidays!$A$2:$A$20 lists dates to skip in addition to weekends.
- 04The result is a serial date number. Format the cell as a date to read it.
The same logic in four tools
=WORKDAY(A2,10,Holidays!$A$2:$A$20)=WORKDAY(A2,10,Holidays!$A$2:$A$20)-- Needs a calendar table with one row per date and an is_business_day flag.
SELECT d AS due_date
FROM calendar
WHERE is_business_day AND d > DATE '2026-03-02'
ORDER BY d
OFFSET 9 LIMIT 1;import numpy as np
due = np.busday_offset(
df["invoice_date"].values.astype("datetime64[D]"),
10,
roll="backward",
holidays=holidays, # list of dates
)Mistakes that break it
- !WORKDAY treats Saturday and Sunday as the weekend. For other weekends use WORKDAY.INTL.
- !Holiday cells must be real dates, not text.
- !The result shows as a number such as 46082 until you apply a date format.
- !SQL has no standard business-day function, so the SQL version relies on a calendar table you maintain.
Common questions
- What is the difference from NETWORKDAYS?
- NETWORKDAYS counts working days between two dates. WORKDAY finds the date after a number of working days.
- Does it count the start date?
- No. WORKDAY(Monday,1) returns Tuesday.
Got a version of this with your own ranges?
Paste it into the free translator and get the same breakdown for your exact formula. To run it against a real file, upload the CSV and describe the formula you need in a sentence.