difference in months
Try theses out. I found them in the Excel HELP.
=MONTH(A3)-MONTH(A2)
Calculates difference in months within same year.
=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
Calculates difference in months for dates occurring in different years.
Les
"Londoner" wrote:
Hi there
I have 2 dates and i want to calculate the difference in months not years
Any help will be appreciated
Thanks
Londoner
|