Question

Let's take for example a Hire-date of 10/16/06 in cell A2

=DATEDIF(A2,NOW(),"y")&" years "&DATEDIF(A2,NOW(),"ym")&" months "
and I get 2 years and 10 months

but now I have 3 dates... Hire-date, Term-date, Rehire-date
Is there a forumula that would calculate the years and months in between?

For example
Hire-date = 10/23/06
Term-date = 08/02/08
Rehire-date = 04/06/09

I was able to calculate the months using the forumula
=(DATEDIF(B3,C3,"M")+DATEDIF(D3,NOW(),"M")) = 25

but I am having some trouble changing the 25 into 2 years 1 month

Thanks,

PJS