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

Assign Random Characters to Cells In Excel
In this pose we will see how could we generate random characters in excel and assign random characters to cells […]

Share The Knowledge
Convert Date Into Week Number In VBA
convert a date into week number in vba, how to get week number from today’s date, vba to convert date into week number, excel date to week number

Share The Knowledge
Set Excel Sheet To Portrait And Landscape
This post demonstrates how we could set excel sheet to landscape or portrait layout in excel to achieve our desired layout. Go […]

Share The Knowledge
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 […]

Share The Knowledge