Last Day of the Month

 

To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function.

1. The EOMONTH function below returns the last day of the month.

Last Day of the Month

Note: the EOMONTH function returns the serial number of the date. Apply a Date format to display the date.

2. The EOMONTH function below returns the same date. Use the DATE function in Excel to hardcode a date.

EOMONTH and DATE

Let's kick it up a notch! Use the second argument of the EOMONTH function to specify a number of months in the future or in the past.

3. The EOMONTH function below returns the last day of the next month.

Last Day of the Next Month

4. The EOMONTH function below returns the last day of the previous month.

Last Day of the Previous Month

5. The EOMONTH function below returns the last day of the month, 8 months in the past!

Last Day of the Month, 8 Months Before Date

Explanation: = 6 - 8 = -2 = October (-2 + 12 = 10) in 2015!

6. Use EOMONTH and TODAY to return the last day of the current month.

EOMONTH and TODAY

Note: today is January 15th, 2022.

7. Finally, to find the first day of the month in Excel, simply use DATE, YEAR and MONTH.

First Day of the Month

Explanation: the DATE function accepts three arguments: year, month and day. Use YEAR to get the year of a date. Use MONTH to get the month of a date.