calculate date differences in years and months

How do I calculate differences in dates in months and years? I can do days,
months, and years, but not a combination.

Hi Joyce

something like this
=DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months"

with your starting date in A1 and your ending date in B1

Cheers
JulieD

"Joyce" <Joyce@discussions.microsoft.com> wrote in message
news:37871A87-956D-40BA-82E6-9D4694FE0326@microsoft.com...
> How do I calculate differences in dates in months and years? I can do
> days,
> months, and years, but not a combination.