EOMONTH Function
The EOMONTH function returns the end of the month that is a specified number of months before or after a given date.
Syntax
EOMONTH(start_date, months)
start_date
: The starting date.months
: The number of months to add (positive) or subtract (negative).
Examples
- Basic Example
Find the end of the month 6 months after August 14, 2024:
=EOMONTH(DATE(2024, 8, 14), 6)
- Subtracting Months
Find the end of the month 3 months before August 14, 2024:
=EOMONTH(DATE(2024, 8, 14), -3)
Notes
- This function is useful for determining the end date of a month given a starting date and a number of months.
Related Functions
- EDATE: Returns a date that is a specified number of months before or after a given date.