Excel EOMONTH function

To get the date that is a specific number of months before or after a given start date, the EDTAE function can do you a favor. Here is an EOMONTH function which is similar with the EDATE function, but, it returns the last day of month after adding or subtracting a number of months from a date.

---

 Syntax:

The syntax for the EOMONTH function in Excel is:

---

 Arguments:

• Start_date: A valid date in Excel that indicates the start date.
• Months: The number of months before or after start date, it can be positive or negative value. A positive value for months to get a date in the future, and a negative value for date in the past.

---

 Return:

Return last day of month date n months in future or past

---

 Usage:

To get the last day of the month that is a specific number of months before or after a given start date, please enter the following formula, and you will get a serial numbers, see screenshot:

Then, you should go to the Format Cells dialog box to format the serial numbers as a normal date format as you need, see screenshot:

Note: In the above formula, A2 is the start date you want to use, B2 is the cell contains the month number you want to add.

Tips: You can also replace the cell references in the above formulas with the date text string and month number, such as:

---

Excel Productivity Tools