Convert Decimal Ages to Days Months and Years

[Stephen_IV]

I have a list of decimal birthdates that I would like to convert to Days, months, and years.
Any help would be appreciated. Thanks in advance!

17.07123288 16.93150685 16.90136986 16.36712329 16.36712329 16.77808219 16.72054795 16.31780822 15.6109589 11.77260274 12.10410959 16.69315068 5.843835616 5.843835616 16.49589041 14.79726027 15.33150685 15.03561644

 

[awoohaw]

Mr Excel Questions4.xlsm
	A	B
12
13	14.38630137	14 Years 5 Months 20 days
Sheet4

Cell Formulas
Range	Formula
B13	B13	=TEXT(INT(A13),"0") & " Years " &TEXT(MOD(A13,1)*365,"m")&" Months " &TEXT(MOD(A13,1)*365,"d")&" days"

 

[awoohaw]

Mr Excel Questions4.xlsm
	A	B
12
13	14.38630137	14 Years 5 Months 20 days
Sheet4

Cell Formulas
Range	Formula
B13	B13	=TEXT(INT(A13),"0") & " Years " &TEXT(MOD(A13,1)*365,"m")&" Months " &TEXT(MOD(A13,1)*365,"d")&" days"

actually this will fail for leap years, so ignore.

 

[Fluff]

Realised the days are completely wrong as I forgot to divide by 12, this should be better.

Fluff.xlsm
	A	B
1
2	17.0712329	17 years 0 months 25 Days
3	16.9315068	16 years 11 months 5 Days
4	16.9013699	16 years 10 months 24 Days
5	16.3671233	16 years 4 months 12 Days
6	16.3671233	16 years 4 months 12 Days
7	16.7780822	16 years 9 months 10 Days
8	16.7205479	16 years 8 months 19 Days
9	16.3178082	16 years 3 months 24 Days
10	15.6109589	15 years 7 months 10 Days
11	11.7726027	11 years 9 months 8 Days
12	12.1041096	12 years 1 months 7 Days
13	16.6931507	16 years 8 months 9 Days
14	5.84383562	5 years 10 months 3 Days
15	5.84383562	5 years 10 months 3 Days
16	16.4958904	16 years 5 months 28 Days
17	14.7972603	14 years 9 months 17 Days
18	15.3315068	15 years 3 months 29 Days
19	15.0356164	15 years 0 months 13 Days
20	13.2	13 years 2 months 12 Days
21	14.3863014	14 years 4 months 19 Days
22	11.8958904	11 years 10 months 22 Days
23	9.50410959	9 years 6 months 1 Days
24	15.8082192	15 years 9 months 21 Days
25	13.2082192	13 years 2 months 15 Days
Data

Cell Formulas
Range	Formula
B2:B25	B2	=LET(m,MOD(A2,1)*12,INT(A2)&" years "&INT(m)&" months "&INT(MOD(m,1)*365/12)&" Days")

 

[Stephen_IV]

Fluff, appreciate the update!!!

 

[Fluff]

You're welcome.