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.

Capture

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.

Capture

Hope this helped.

Share The Knowledge

Random Posts

  • Print Cell Height And Cell Width Of A Cell In Excel
    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

Leave a Reply