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](images/faq_images/elapsed-number-of-months-1.png)
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?