how to convert 12/10/1970 to years/months/days

[Guest]

can any one help me to covert 12/10/1970 to years/months/days

 

[Roger Govier]

Hi

With date in A1
=Year(A1)
=Month(A1)
=Day(A1)

 

[Bob Phillips]

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)

 

[Guest]

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