Convert years to years and days

K

Kimmie B

I want to create a formula that converts years into years and days.

For example, turn 7.65 years to text that reads: 7 years, 237 days.
I want the formula to round the days to the nearest whole number.

I am VERY new at Excel, so please provide explicit instructions.

Thanks in advance for your help!
 
G

Gary''s Student

For normal years:
=INT(A1)&" yrs "&ROUND((A1-INT(A1))*365,0) & " days"
For Leap Years:
=INT(A1)&" yrs "&ROUND((A1-INT(A1))*366,0) & " days"
 
K

Kimmie B

You're an angel. Thank you.

Gary''s Student said:
For normal years:
=INT(A1)&" yrs "&ROUND((A1-INT(A1))*365,0) & " days"
For Leap Years:
=INT(A1)&" yrs "&ROUND((A1-INT(A1))*366,0) & " days"
Click to expand...
 
Top