EOMONTH function. Get the end-of-month date (serial value).(Microsoft Excel)
Get the end-of-month date (serial value).
How it works
=EOMONTH(Start_date,Months)
| Argument | Omission | Specify |
|---|---|---|
| Start_date | Required argument. | Date (serial value) or cell to get the last day of the month. |
| Months | Required argument. | Calculate the last day of the month after how many months after the start date. The current month is 0. |
Example Results
"Start_date" days have no effect on the results.
Leap years are taken into account.
---