EOMONTH function
Returns the serial number of the last day of the month before or after a specified number of months
Syntax
EOMONTH(start_date, months)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| start_date | Yes | A date that represents the starting date."2011-1-1" |
| months | Yes | The number of months before or after start_date.1 |
Try EOMONTH
Let leap February determine its last date
=EOMONTH(A2,B2)A zero month shift selects February 2024 and returns February 29 as a numeric date serial. This is a calendar month end; it does not exclude weekly closures or holidays.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
EOMONTH · top-level call
=EOMONTH(A2,B2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.