Convert years to years and days

Convert years to years and days

Post by S2ltbWllIE » Thu, 09 Feb 2006 04:34:41


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

Post by R2FyeScncy » Thu, 09 Feb 2006 04:45:26

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

 
 
 

Convert years to years and days

Post by S2ltbWllIE » Thu, 09 Feb 2006 04:58:19

You're an angel. Thank you.
 
 
 

Convert years to years and days

Post by R2FyeScncy » Thu, 09 Feb 2006 05:06:27

You are very welcome
--
Gary''s Student