Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calculate a whole number with a remainder


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.







This discussion has been closed.