excel - 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 of our Technical Tips solutions are applied. Back up your data; test thoroughly before using on live data.