Excel Last Day of Month Formula

The quick answer to finding the last day of the month is to use the EOMONTH() function.
For example, to determine the serial date number for the last day of the current month, use

To avoid using the EOMONTH formula, you can use the fact that the zeroth day of the next month is the last day of the current month:

There are many ways to do this, such as subtracting a day from the first day of the next month:

Of course, NOW() could be replaced with a reference to a date cell, or in the case of the last formula ...
where month and year are named references to cells.


Anonymous said...

Dude, nice EOMonth explanation

Anonymous said...

Great post, very helpful in automating some of our monthly shipment tracking spreadsheets. Thank you!

Anonymous said...

Thanks for this very clear and straight forward explanation. Much appreciated