Articles → EXCEL FORMULA → EOMONTH Function In Excel

EOMONTH Function In Excel

Purpose

Syntax

EOMONTH(“date”,”no of months”)

1. Date – Here, we can specify the valid date.
2. No of months – Here, we can specify the number of months. If the value is zero, then EOMONTH function will return the last date of the current month. If one, then last date of next month and so on.

Example