How do I display months and years between two dates
 

I need to display the months and years between two dates in two separate
fields.

I want a result such as 3 months, 2 years with months in B1 and years in B2.

Any suggestions? Thank you!

later date in f5, earlier in f4
=DATEDIF(F5,F4,"m")

--
Don Guillett
SalesAid Software

"JSmith" wrote in message
...
I need to display the months and years between two dates in two separate
fields.

I want a result such as 3 months, 2 years with months in B1 and years in
B2.

Any suggestions? Thank you!