EOMONTH function returns the last day of the month before or after the specified months.
Formula:
=EOMONTH(start_date, months)
Explanations:
- Start_date is required, the start date you need to have the date months before or after.
- Months is required, the number of months you specified.
Cautions:
- Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.
- When month is not an integer, it is truncated to use the integer.
