Convert years to years and days
 

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!

Convert years to years and days
 

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"

--
Gary''s Student


"Kimmie B" wrote:

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!

Convert years to years and days
 

You're an angel. Thank you.

"Gary''s Student" wrote:

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"

--
Gary''s Student


"Kimmie B" wrote:

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!

Convert years to years and days
 

You are very welcome
--
Gary''s Student


"Kimmie B" wrote:

You're an angel. Thank you.

"Gary''s Student" wrote:

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"

--
Gary''s Student


"Kimmie B" wrote:

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!