tel 01732 833085
e david wallis
home > technical tips > excel tip
How do I calculate the last day of next month?
This is one formula that will calculate the last day of next month:
=DATE(YEAR(TODAY()),MONTH(TODAY())+2,1)-1
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.