Ravindra BagaleCourses & study guides Track your progress

Excel WORKDAY Function

By · Last updated:

Chala mitrano — today WORKDAY. Start on a date, jump N working days forward or back — weekends skip themselves.

Fictional sample data for learning. SLA deadlines in Hyderabad support and Boston SaaS.

Purpose

Return a date that is N working days before or after a start date.

Return value

A date serial.

Syntax

WORKDAY(start_date, days, [holidays])

Arguments

ArgumentRequired?Description
start_dateRequiredStarting date.
daysRequiredWorkdays to shift (negative goes backward).
holidaysOptionalHoliday dates to skip.

Version

All modern Excel; LibreOffice WORKDAY too.

How to use — Why → What → How

Why: SLAs say ‘reply in 3 working days’. WORKDAY computes the due date. SLA deadlines in Hyderabad support and Boston SaaS. In Indian back offices and foreign sister teams, WORKDAY shows up on leave, SLA and invoice sheets every week.

What: WORKDAY shifts by weekdays only; optional holidays are also skipped. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =WORKDAY(A2,3).
  2. Add holiday range when needed.
  3. Format as Date.

Ravindra Bagale's Tip

Friends, after you learn WORKDAY, open a real leave or project sheet and find one cell this function would fix this week.

Ravindra Bagale's Tip

Friends, sleep on WORKDAY and rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business question in plain words before you type =WORKDAY.

Ravindra Bagale's Tip

Friends, after you finish WORKDAY, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Ravindra Bagale's Tip

Friends, treat WORKDAY like a seatbelt on date sheets — use it before a manager asks why the deadline slipped.

Download practice file: practice-workday.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) +10 workdays

Hyderabad SLA.

Start₹ credit
2026-10-01500
Formula: =WORKDAY(A2,10)

Result: 2026-10-15

What it means: Tenth weekday after 1 Oct 2026.

2) With 2 Oct holiday

Skip Gandhi Jayanti.

StartHol
2026-10-012026-10-02
Formula: =WORKDAY(A2,10,B2)

Result: 2026-10-16

What it means: Holiday pushes the due date later.

3) −5 workdays

Boston prep.

Deadline$
2026-10-15120
Formula: =WORKDAY(A2,-5)

Result: 2026-10-08

What it means: Five weekdays before.

4) +1 from Friday

Next workday.

Start
2026-10-02
Formula: =WORKDAY(A2,1)

Result: 2026-10-05

What it means: Friday +1 workday → Monday.

5) Zero days

Edge.

Start
2026-10-01
Formula: =WORKDAY(A2,0)

Result: 2026-10-01

What it means: Zero returns the start date.

6) Chain SLA

Two hops.

Start
2026-10-01
Formula: =WORKDAY(WORKDAY(A2,5),5)

Result: 2026-10-15

What it means: Nested shifts (or just use 10).

Common errors and fixes

#NUM! — Result out of range / bad inputs. Fix: Check days and dates.
#VALUE! — Non-date. Fix: Fix types.
Wrong due date — Forgot holidays. Fix: Pass holiday range.

Notes and tips

  • Revisit WORKDAY errors after the quiz.
  • Build one example from memory.
  • Check date formats if results look wrong.
  • Teach one tip in Marathi or Hindi.
  • Keep currency consistent in one column (practice mixes ₹ $ £ €).
  • Note fallbacks when Excel versions differ.
  • Drill: compute three SLA due dates with and without 2 Oct.
  • WORKDAY vs WORKDAY.INTL: default Sat–Sun vs custom weekend.
  • Fictional sample data only.
  • Print the WORKDAY revision card.
  • Ask juniors to predict before Enter.
  • Track your top mistake monthly.
  • SLA deadlines in Hyderabad support and Boston SaaS.
  • Excel stores dates as serials.
  • Verify with a known calendar before long chains.
  • Print the revision card for WORKDAY and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • If a result looks wrong, check date formats and regional settings before changing the formula.
  • Date serial numbers are how Excel stores dates — formatting only changes the display.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • Classroom habit: after WORKDAY, open yesterday’s real workbook and find one place this function saves time.
  • For interviews, explain why calendar days and working days differ on a project that crosses a weekend.

In real work

Drill: compute three SLA due dates with and without 2 Oct. SLA deadlines in Hyderabad support and Boston SaaS. Classroom drill: write three brand-new WORKDAY formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known calendar date before trusting a long chain of date formulas. Keep a personal notebook of the one mistake you make most often with this function; review it monthly. When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.

How it compares

WORKDAY vs WORKDAY.INTL: default Sat–Sun vs custom weekend.

Interview corner

SLA due date?
WORKDAY.
Holidays?
Third argument.
Custom weekend?
WORKDAY.INTL.

WORKDAY.INTL, NETWORKDAYS, EDATE

Practice tasks (10)

  1. Task 1. +10 workdays from 1 Oct 2026.
    WORKDAY.
  2. Task 2. Exclude 2 Oct.
    Holidays.
  3. Task 3. −5 from 15 Oct.
    Neg.
  4. Task 4. Fri+1.
    Mon.
  5. Task 5. days=0 check.
    Edge.
  6. Task 6. Explain SLA use.
    Interview.
  7. Task 7. Format Date.
    Fmt.
  8. Task 8. Compare calendar +10 vs work +10.
    EDATE/DATE.
  9. Task 9. Doc holidays list.
    Note.
  10. Task 10. Bonus: INTL for Fri+Sat.
    Related.

Quick quiz

Q1. WORKDAY skips:
Q2. Negative days:
Q3. Fri + 1 workday:
Q4. Custom weekend:
Q5. days=0 returns:

Answers: Q1=Weekends (+ holidays if given), Q2=Go backward, Q3=Mon, Q4=WORKDAY.INTL, Q5=Start date (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: WORKDAY
WORKDAY revision card