Formualizer Docs
ReferenceFunctionsDate & Time Functions

WORKDAY

WORKDAY: Returns the date serial that is a given number of weekdays from a start date.

Summary

Returns the date serial that is a given number of weekdays from a start date.

Remarks

  • Positive days moves forward; negative days moves backward.
  • Weekends are fixed to Saturday and Sunday.
  • The optional holidays argument is currently accepted but ignored; holiday exclusions are not yet supported.
  • Input and output serials use Excel 1900 date mapping.

Examples

Move forward by five workdays
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45299
Holiday argument currently has no effect
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45299

FAQ

Does WORKDAY include the start date when days=0?

Yes. With zero offset, WORKDAY returns the start date serial unchanged; nonzero offsets skip weekend days while stepping.

Runtime metadata

Category

Date & Time

Signature

WORKDAY(arg1: Number, arg2: Number, arg3…: Any)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/weekday_workday.rs

WEEKNUM

WEEKNUM: Returns the week number of the year for a date serial.

YEAR

Extracts the calendar year from a date serial.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes WORKDAY include the start date when days=0?Runtime metadata