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.
The syntax for the EOMONTH function in Excel is:
Return last day of month date n months in future or past
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: