It returns the last day of the month that is a given number of months before or after the specified date.
The syntax of the function is the following:
EOMONTH(start_date, months)
start_date: The start date.
months: The months before (negative value) or after (positive value) the start_date. If it is not an integer it is truncated.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the EOMONTH function:
In the cell Α2 calculate the end of next month of the date of the cell A1, with the use of the proper function.