Formula guide · Excel and Google Sheets · Updated May 13, 2026
WORKDAY Formula
Use WORKDAY to calculate a date after a number of working days.
Quick Answer
WORKDAY moves forward or backward by business days, skipping Saturdays and Sundays by default.
Copyable Formula
=WORKDAY(A2,10,H2:H12)Syntax
=WORKDAY(start_date, days, [holidays])Excel and Google Sheets
Worked Example
| A | H |
|---|---|
| Start date | Holiday list |
| 2026-05-13 | 2026-05-25 |
Result: Returns the due date 10 workdays after the start date, excluding listed holidays.
Steps
- Enter the start date.
- Enter the number of business days to move.
- Add a holiday range if your deadline should skip holidays.
Common Mistakes
- Forgetting holidays when planning official deadlines.
- Using WORKDAY when weekend days should count.
- Not using WORKDAY.INTL when weekends differ from Saturday/Sunday.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.