How to Use WORKDAY in Excel
WORKDAY returns a future or past business date after a set number of working days. Here's the syntax, a project example, holiday handling, and the mistakes that shift deadlines.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
WORKDAY returns a date that is a certain number of business days before or after another date. Use it when you want Excel to calculate a real deadline instead of forcing someone to count days manually.
That makes it useful for project timelines, approval windows, onboarding tasks, review cycles, and any schedule where weekends and holidays should not push work onto the wrong date.
The syntax
=WORKDAY(start_date, days, [holidays])- start_date — the date you are starting from
- days — the number of working days to move forward or backward
- [holidays] — an optional range of dates to exclude
Positive numbers move forward. Negative numbers move backward.
Basic example
If A2 contains a kickoff date and the task should finish 10 business days later:
=WORKDAY(A2, 10)Excel returns the due date after skipping weekends automatically.
That is often cleaner than building manual calendar logic in a project tracker template or Gantt chart template.
Step-by-step deadline example
Say creative review starts in A2, normally takes 7 working days, and your company holiday list is in H2:H5.
Step 1. Put the start date in A2.
Step 2. Enter the business-day duration in B2.
Step 3. Use:
=WORKDAY(A2, B2, H2:H5)Excel returns the actual due date, excluding weekends and any listed holidays.
That matters because a raw A2+B2 formula will land on weekends without warning.
Move backward from a deadline
WORKDAY is also useful in reverse.
If C2 is the launch date and legal needs 3 business days before launch:
=WORKDAY(C2, -3, H2:H5)This gives you the latest date legal review can start without slipping the plan.
WORKDAY vs NETWORKDAYS
These two functions solve related but different problems:
| Function | What it returns |
|---|---|
NETWORKDAYS | Number of business days between two dates |
WORKDAY | A business date after moving forward or backward by a number of workdays |
If you need the count, use NETWORKDAYS.
If you need the resulting date, use WORKDAY.
Common WORKDAY mistakes
| Mistake | What happens | Fix |
|---|---|---|
Adding days with A2+10 instead of WORKDAY | Deadline lands on a weekend | Use WORKDAY(A2, 10, holidays) |
| Forgetting holidays | Deadline is too early | Include the holiday range |
| Using text instead of real dates | Wrong date or #VALUE! | Convert text into real Excel dates |
| Expecting a custom weekend pattern | Date still counts Friday or Sunday incorrectly | Use WORKDAY.INTL for non-standard weekends |
→ NOTE
If your operating calendar does not use a standard Saturday/Sunday weekend, WORKDAY.INTL is the right function. WORKDAY assumes the default weekend pattern.
Where WORKDAY fits best
WORKDAY is strongest in sheets that need date outputs, not just duration counts. Common examples:
- setting milestone due dates from a kickoff date
- calculating when approvals must start
- back-planning launch steps from a fixed release date
- generating follow-up dates in recurring operational workflows
That is why it pairs well with timeline and staffing templates where the next real date matters more than the raw number of days.
The Griddy way
WORKDAY is easy to get wrong when holiday lists move, the start date lives in a different sheet, or the workflow needs to count backward from a launch instead of forward from a kickoff.
"Take the client kickoff date, add 12 business days, exclude our holiday list, and return the review deadline"
Griddy can build the correct WORKDAY formula for your sheet structure and drop the date directly into your schedule.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Turn durations into real due dates
WORKDAY fits timeline and staffing sheets where a task duration needs to become an actual business-date deadline instead of a rough estimate.
Gantt Chart
Plan project phases, owners, and milestones on a 12-week timeline. Colour-coded bars make schedules easy to scan in Excel, Google Sheets, or Griddy.
Gantt Chart for Product Launches
Plan launch milestones, owners, dependencies, and timing in one free Gantt chart spreadsheet built for product launches and release work.
Gantt Chart for Agencies
Plan agency timelines, client phases, approvals, and launch milestones in one free Gantt chart spreadsheet for service delivery teams.
Project Tracker
Track tasks, owners, priorities, due dates, and blockers in one delivery board. Group work by stream, review progress, and keep next steps visible.
Project Tracker for Marketing Teams
Track campaign work, owners, deadlines, approvals, and blockers in one free marketing project tracker spreadsheet for Excel and Google Sheets.
Project Tracker for Client Work
Track client deliverables, owners, due dates, approvals, and blockers in one free project tracker spreadsheet built for service teams.
Employee Schedule
Plan a weekly staff rota with day-by-day shifts, weekly hours, overtime flags, and a manager snapshot block. Free template for teams, shops, and clinics.