Deduct one date from another

Hi People

Can someone give me a formula that will allow me to deduct one date from another and return a value in years and months? Many Thanks for your kind help!

ExcelBob

Hi, Bob. Try:

=DATEDIF(A1,A2,"Y")&" Years "&DATEDIF(A1,A2,"M")&" Months"

HTH

Jason

Hello Jason,

I think you'd need a tiny tweak......2nd DATEDIF should use "YM" as the 3rd argument, i.e.

=DATEDIF(A1,A2,"Y")&" Years "&DATEDIF(A1,A2,"YM")&" Months"

Ah, yes. Good catch. Thanks, DLL.

Jason