Let’s see how to find out the last day of next month from a given date in excel.
Suppose we have as scenario in which the due date for the payment of bill is the last day of the next month from the day bill was generated.
We will see a simple formula to find the last day of next month in excel by using DTAE, YEAR and MONTH formula in excel.
Enter the formula =DATE(YEAR(A2),MONTH(A2)+2,1)-1 in cell B2 and it will give you the desired result i.e. Bill due date is 31-07-2016.
Hope this helped.