Date & Timeintermediate
Calculate a due date skipping weekends with WORKDAY
=WORKDAY(A2,30)
Function reference
WORKDAY in Excel & Google Sheets
WORKDAY is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 intermediateBuild a custom WORKDAY formula →
When to use WORKDAY
- Calculate invoice payment due dates, project milestone deadlines, or delivery estimates based on business days rather than calendar days.
Worked examples (1)
Common errors with WORKDAY
Result is off by one day
WORKDAY does not count the start date. The first working day it counts is the day after the start date. If you need to include the start date, subtract 1 from the days argument.
Weekends in different countries
WORKDAY always skips Saturday and Sunday. For non-standard work weeks, use WORKDAY.INTL and specify the weekend pattern.
Frequently asked questions
How do I also skip public holidays?
Store your holiday dates in a separate range, for example H2:H20, and add it as the third argument — =WORKDAY(A2,30,H2:H20).
Need a custom variation?
Describe your specific WORKDAY problem and get a formula written for your exact data.
Open generator with WORKDAY