SheetSense

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.

fx
=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

  1. 01A2 is the start date. It is not counted as one of the 10 days.
  2. 0210 is the number of working days to move forward. A negative number moves back.
  3. 03Holidays!$A$2:$A$20 lists dates to skip in addition to weekends.
  4. 04The result is a serial date number. Format the cell as a date to read it.

The same logic in four tools

Excel
=WORKDAY(A2,10,Holidays!$A$2:$A$20)
Google Sheets
=WORKDAY(A2,10,Holidays!$A$2:$A$20)
SQL
-- 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;
Python (pandas)
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.