difference two date

[RKS]

Anyone pl help me. How calculate difference between two date in the
year,month & date. I want to difference year, month & date ( all are
calculate).

Ex.
a1 = {01/12/1950}
b1={01/11/1960}

result we want b1-a1 = 9 year 1 month 10 days. (These format)

Pl Help me.

[KL]

=DATEDIF(A1,B1,"Y")&" years "&DATEDIF(A1,B1,"Ym")&" months
"&DATEDIF(A1,B1,"Md")&" days"

Regards,
KL


"RKS" <[email protected]> wrote in message
news:[email protected]...
> Anyone pl help me. How calculate difference between two date in the
> year,month & date. I want to difference year, month & date ( all are
> calculate).
>
> Ex.
> a1 = {01/12/1950}
> b1={01/11/1960}
>
> result we want b1-a1 = 9 year 1 month 10 days. (These format)
>
> Pl Help me.
>