Formualizer Docs
ReferenceFunctionsDate & Time Functions

DATE

Returns the serial number for a calendar date from year, month, and day.

Summary

DATE normalizes out-of-range month and day values to produce a valid calendar date.

Remarks

  • Years in the range 0..=1899 are interpreted as 1900..=3799 for Excel compatibility.
  • The returned serial is date-system aware and depends on the active workbook system (1900 vs 1904).
  • In the 1900 system, serial mapping preserves Excel's historical phantom 1900-02-29 behavior.

Examples

Build a standard date
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45306
Normalize overflowing month input
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45662

FAQ

Does DATE follow the workbook 1900/1904 date system?

Yes. DATE emits a serial in the active workbook date system, so the same calendar date can map to different serials across 1900 vs 1904 mode.

Runtime metadata

Category

Date & Time

Signature

DATE(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

Date & Time Functions

Generated reference pages for Date & Time functions.

DATEDIF

DATEDIF: Returns the difference between two dates in a requested unit.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes DATE follow the workbook 1900/1904 date system?Runtime metadata