Excel Function Translator Logo
    The Excel Translator

    WORKDAY

    Date & Time

    Returns a date that is a specified number of working days before or after a start date.

    Translations
    EnglishWORKDAY
    FrenchSERIE.JOUR.OUVRE
    SpanishDIA.LAB
    GermanARBEITSTAG
    ItalianGIORNO.LAVORATIVO
    PortugueseDIATRABALHO
    DutchWERKDAG
    PolishDZIEŃ.ROBOCZY
    RussianРАБДЕНЬ
    TurkishİŞGÜNÜ
    CzechWORKDAY
    HungarianMUNKANAP
    SwedishARBETSDAGAR
    DanishARBEJDSDAG
    FinnishTYÖPÄIVÄ
    Syntax
    WORKDAY(start_date, days, [holidays])

    Arguments

    • start_dateThe starting date
    • daysWorking days to add
    • holidaysDates to exclude(optional)
    Examples
    =WORKDAY(TODAY(),5)
    5 work days later

    Five working days from now

    =WORKDAY(A1,10,Holidays)
    Project deadline

    10 days excluding holidays

    =WORKDAY(TODAY(),-3)
    3 work days ago

    Working days backward

    Tips & Best Practices
    • •Excludes weekends automatically
    • •Use WORKDAY.INTL for custom weekends
    • •Great for project planning
    Common Mistakes
    • •Forgetting to supply a holiday list, which makes WORKDAY count public holidays as valid working days when calculating the resulting date
    • •Using a negative number of days expecting an error - WORKDAY actually supports negative values fine, counting backward instead of forward
    • •Assuming WORKDAY excludes Saturday and Sunday specifically for every company - if your weekend pattern is different, WORKDAY.INTL is the one to use instead
    Related Functions
    NETWORKDAYSCounts the number of workdays between two dates, the reverse of calculating a date from a day count.
    EDATEShifts a date by whole months instead of workdays.
    TODAYOften used as the starting date for a WORKDAY calculation.
    Frequently Asked Questions

    Does WORKDAY skip public holidays automatically?

    No, only weekends are skipped by default. Supply a range of holiday dates as the third argument to have it skip those too.

    Can WORKDAY calculate a date in the past?

    Yes, use a negative number of days, like WORKDAY(A1,-10), to go backward that many workdays instead of forward.

    What if my weekend isn't Saturday and Sunday?

    Use WORKDAY.INTL instead, which lets you specify a custom weekend pattern.

    Need to translate a formula using WORKDAY?

    Use our translator to convert your complete formula