EOMONTH
Refers to End Of Month, returns the serial number of the last day from the given date’s month could be before or after specified month. This function is very helpful to get last day.
Syntax
=EOMONTH(start_date, months)
Parameters
- start_date: refers to a valid date as input on which specified months need to be calculated to return last day.
- months: refers to a positive or negative integer, the number of months would be calculated based on number sign, if negative number then subtract would be performed else addition would be performed to calculate months.
Example

Output

Next >> CHAR Function or CHAR Formula in Excel