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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how to convert 12/10/1970 to years/months/days (https://www.excelbanter.com/new-users-excel/116638-how-convert-12-10-1970-years-months-days.html)

doctor who golf

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

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

Roger Govier

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

Hi

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

--
Regards

Roger Govier

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

Bob Phillips

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

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

Rookie 1st class

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

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

All times are GMT +1. The time now is 07:54 AM.