# Find Last Day Of Next Month In Excel

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.

Share The Knowledge
• #### Random Posts

• Print Cell Height And Cell Width Of A Cell In Excel

print cell’s dimension in excel , print row height and row width in excel, get row height and width of a range in excel, excel formula to get cell’s height and width, find dimension of a cell in excel

Share The Knowledge
• Generate Random Username In Excel

Let’s understand how to generate random username in excel. We will see how to generate random username in excel with […]

Share The Knowledge
• Counting Frequency Of Max In A Column In Excel

The post demonstrates how we could find the frequency of the maximum number in a column i.e. how many times […]

Share The Knowledge
• Replace Tilde In Excel

We will see how to find and replace “~” in excel. As tilde is a special character in excel, it […]

Share The Knowledge