ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / DATE & TIME

EDATE Excel function

Shifts a date by months.

Correct sentence to use

Move [date] by [number] months.

Modify this query in PlainFormula →

Example formula

=EDATE(A2,3)

Returns a date offset by months.

Syntax

EDATE(start_date, months)

Argument signature: start_date, months

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions