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
Options
Comments
-
=INT(Days1 / 365) + " Years " + (Days1 - 365 * INT(Days1 / 365)) + " Days"
-
John,
Thank you Sir, this is perfect!
D
This discussion has been closed.