ReferenceFunctionsDate & Time Functions
EOMONTH
EOMONTH: Returns the serial for the last day of the month at a month offset from a start date.
Summary
Returns the serial for the last day of the month at a month offset from a start date.
Remarks
monthsis truncated to an integer before offset calculation.- The returned date is always the month-end date for the target month.
- Serials are interpreted and returned using Excel 1900 mapping rather than workbook
1904mode.
Examples
Get end of current month
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
44957
Get end of month two months ahead
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
45382
Related functions
FAQ
Does EOMONTH always return a month-end date?
Yes. Regardless of the start day, EOMONTH returns the final calendar day of the target month after offset.
Runtime metadata
Category
Date & Time
Signature
EOMONTH(arg1: Number, arg2: Number)Arity
min 2, max 2
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source