EOMONTH

Posted on 22-01-2020 , by: admin , in , 0 Comments

eomonth

What Does It Do?
This function will show the last day of the month which is a specified number of months before or after a given date.

Syntax
=EOMONTH(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted to represent a date by using the Format,Cells,Number,Date command.

StartDate Plus Months End Of Month
5-Jan-98 2 35885  =EOMONTH(C4,D4)
5-Jan-98 2 31-Mar-98  =EOMONTH(C5,D5)
5-Jan-98 -2 30-Nov-97  =EOMONTH(C6,D6)

Leave a comment