Calculate a whole number with a remainder

Dwayne Anjewierden

Hey All,

 

I have a column that calculates the time a vehicle is in our fleet.  It returns a whole number such as 500 days.  Is there a formula that will convert that to number of years with a remainder being the number of days.  (1 year 135 days). 

 

Any help is much appreciated.

 

Thanks

 

Dwayne

John Sauber

=INT(Days1 / 365) + " Years " + (Days1 - 365 * INT(Days1 / 365)) + " Days"

Dwayne Anjewierden

John,

 

Thank you Sir, this is perfect!

 

D