Returns the date of the last day of a month which falls months away from the start date.


EOMONTH(StartDate; Months)

StartDate is a date (the starting point of the calculation).

Months is the number of months before (negative) or after (positive) the start date.


माह का अंतिम दिन कौन सा है जो 14 सितम्बर 2001 के 6 माह पश्चात् आता है?

=EOMONTH(DATE(2001;9;14);6) returns the serial number 37346. Formatted as a date, this is 2002-03-31.

=EOMONTH("2001-09-14";6) works as well. If the date is given as string, it has to be in ISO format.

Please support us!