Calc difference between two dates without DATEIF

[charlesstricklin]

I'm using a 2010 version of Excel (Don't judge!) and it does not have DATEIF as one of its functions. I know that I use:

=INT(YEARFRAC(D2,TODAY()))&" years,"

...to calculate the years, but how do I add the number of months?

 

[Fluff]

xl 2010 does have the DateDif function, it's just not listed any more.

 

[charlesstricklin]

DATEDIF! I was totally misreading it. Thanks!

 

[Fluff]

Glad to help & thanks for the feedback.