EOMONTH function. Get the end-of-month date (serial value).(Microsoft Excel)

Japanese version.

Get the end-of-month date (serial value).

How it works

Start_dateRequired argument.Date (serial value) or cell to get the last day of the month.
MonthsRequired 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.



Date & Time(Microsoft Excel Functions)