WORKDAY Function Generator
WORKDAY returns a date that is a given number of business days before or after a start date, excluding weekends and optional holidays. Use for SLA dates, delivery estimates, and project timelines.
Syntax
=WORKDAY(start_date, days, [holidays])Try it — generate a WORKDAY formula
Examples
10 business days from today
=WORKDAY(TODAY(), 10)Adds 10 weekdays, skipping Sat/Sun.
With holiday exclusions
=WORKDAY(A2, 5, Holidays!A:A)Also skips dates in the Holidays range.
Backward: due date minus 3
=WORKDAY(A2, -3)Negative days = going backward.
Tips
- ✓For custom weekends (e.g., Fri-Sat), use WORKDAY.INTL.
- ✓Holidays arg must be a range of valid dates.
- ✓Returns a serial number — format as date.
Related Formulas
NETWORKDAYS
NETWORKDAYS calculates the number of working days between two dates, automatical...
EOMONTH
EOMONTH returns the last day of the month that is a specified number of months b...
DATEDIF
DATEDIF calculates the difference between two dates in days, months, or years. P...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free