Use the formula below to calculate the number of months between two dates.
=(YEAR(cell2)-YEAR(cell1))*12+MONTH(cell2)-MONTH(cell1)
For example:
If you want to calculate the number of months between 15/08/1995 and
31/07/2008, do the following.
Enter the first date in cell "A1" and the second date in cell "A2".
Then format both cells using "date format."
Enter the above mentioned formula on cell "A3" as
"=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)" [without double quotation]
This should help..
VKL Narayanan said:
I have two dates say 15/08/1995 and 31/07/2008, I want to calculate the
number of months between these two dates mentioned. how do I do that?