Custom format in helper cell
yyyy/mm/dd
="cell address" in helper cell
Hth
Lou

"Bob Phillips" wrote:

Maybe you mean

=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months,
"&DATEDIF(A1,TODAY(),"MD")&" days"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"doctor who golf" wrote in message
...
can any one help me to covert 12/10/1970 to years/months/days