Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Excel how-to guide
How to workday due date in Excel
Calculate invoice payment due dates, project milestone deadlines, or delivery estimates based on business days rather than calendar days.
Step-by-step instructions
How to workday due date — 3 steps
1
Enter the start date in column A.
2
Enter the number of working days to add as the second argument.
3
Optionally, add a list of holiday dates as a third argument to skip them as well.
Example data
Worked example
| Invoice Date | Due Date (30 days) |
|---|---|
| 2026-03-01 | 2026-04-10 |
| 2026-03-15 | 2026-04-24 |
Common mistakes
Errors to watch out for
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.
FAQ
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).
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Date & Timebeginner
NETWORKDAYS for project timeline planning
=NETWORKDAYS(B2,C2)