Formualizer Docs
ReferenceFunctionsDate & Time Functions

EDATE

EDATE: Returns the serial date offset by a whole number of months from a start date.

Summary

Returns the serial date offset by a whole number of months from a start date.

Remarks

  • months is truncated to an integer before calculation.
  • If the target month has fewer days, the day is clamped to that month's last valid day.
  • Serials are interpreted and emitted with Excel 1900 date mapping (not workbook-specific 1904 mode).

Examples

Add months to first-of-month date
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45017
Clamp month-end overflow
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45351

FAQ

What happens when the start day does not exist in the target month?

EDATE clamps to the last valid day of the target month (for example Jan 31 + 1 month becomes Feb month-end).

Runtime metadata

Category

Date & Time

Signature

EDATE(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

DAYS360

DAYS360: Returns the day count between two dates using a 30/360 convention.

EOMONTH

EOMONTH: Returns the serial for the last day of the month at a month offset from a start date.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens when the start day does not exist in the target month?Runtime metadata