Excel Formula for the Last Day of Next Month

Question

How do I calculate the last day of next month?

Answer

This is one formula that will calculate the last day of next month:

=DATE(YEAR(TODAY()),MONTH(TODAY())+2,1)-1

Disclaimer

DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.