Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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.

Share this Post