deepcalc
DocsWORKDAY

WORKDAY

View as markdown/docs/functions/workday.md Ask Claude about this pageOpens Claude with this page's address

Returns date after given business days.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number (date serial)

Examples

=WORKDAY(DATE(2026,7,27), 10)
Result 46244

Syntax

WORKDAY(start_date, days, [holidays])
start_date
number required
days
number required
holidays
range optional
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year.