Elapsed number of months in Excel

For example, I want to find the number of months between today and the maturity of a bond (say, 15th Apr 2021).

To do it in Excel, here is the answer:

a) Enter the formula =DATEDIF(TODAY(),Y2,"M") in the cell where the the number of months is required. (Y2 should have the Bond Maturity date).

The TODAY() function returns the current Date. The DATEDIF function subtracts the 2 dates (Bond Maturity Date and Current Date). The use of "M" option returns the number of months between the 2 dates.

Note: Instead of "M", if "Y" is used, number of years is returned. Similarly the use of "D" returns the number of days.

excel elapsed number of months


You can find similar Excel Questions and Answer hereunder

1) How can I generate random numbers between 2 limits?

2) How do I get the 2nd highest number in a range of numbers?

3) How can I find the number of working days between 2 dates given a holidays list?

4) Millions thousands custom number formatting in Excel

5) How can I get row count of filtered data?

6) Can I determine the number of times a character appears in a cell using formula?

7) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

8) How to find the cell address from the column number in VBA

9) How do I get the rank of a number in a list of numbers?

10) Can I apply formatting to a number concatenated with a Text?


Here the previous and next chapter