elapsed number of months in Excel

Q15. In Excel, how can I find number of months that has elapsed given 2 dates?

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) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

2) Millions thousands custom number formatting in Excel

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

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

5) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

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

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

8) How can I edit names of all the Shapes in the WorkSheet easily instead of navigating to each Shape and renaming them?

9) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

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

11) Concatenate number with text but keeping in number format in Excel

12) How can I convert Column numbers into Column names for use in range definition?

13) I have test scores for my student population. In Excel, how can I determine confidence interval for my Population Mean?

14) How do I change the rating numbers to rating labels?

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