EOMONTH calculates the last date of a month from a start date. It can calculate dates occurring in the past or in the future. Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH Formula to calculate maturity dates or due dates that fall on the last day of the month. EOMONTH Formula is good to work with dates in Excel.