Calculate Year/Month

[eyemgod]

Hello everyone,

I dont have something too complicated here I think. But i am not able to figure it out.

I have date in two columns and need to calculate so the result is how many year and month in between the two dates.

example:
Column A - 23 Aug 2004
Column B - 23 Oct 2006
Column C (result) - 2 years 2 month

Thanks,

Andre

 

[tmcfadden]

Well, a really simple implementation would be:

=YEAR(B1)-YEAR(A1) & " years, " & MONTH(B1)-MONTH(A1) & " months"

That might not always work for you though. For example, 1-DEC-06 & 1-JAN-07.

-Tim