Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Find Last Day of the Month in Excel

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

1. For example, get the date of the last day of the current month.

Worked Example:   How To Create Budget in Excel

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

Worked Example:   How to Separate Text Strings in Excel

2. For example, get the date of the last day of the next month.

Worked Example:   Count Cells with Text in Excel

3. For example, get the date of the last day of the current month – 8 months = 6 – 8 = -2 = October (-2+12=10), 2015!

Leave a Reply

Your email address will not be published. Required fields are marked *