If the older date is in A1 and the recent date is in B1, then:

=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
DATEDIF(A1,B1,"md") & " days"

--
Gary's Student


"Joe" wrote:

I wud lik to know whtr thr is ne formula for date subtraction, ie., if i gv d
formula for sutracting 2dates, i nd to gt the d/f in mm/dd/yyyy format. i
doubt leap yrs and 30/31 days may pose an issue
--
Thanx n rgds
joe