# Formula for Ternure

Options

Based on the hiring date (column), how can I create a formula for Ternure to be shown in days, months & years?

Thank you

• ✭✭✭✭✭
Options

This will give you how many years based off a hire date. Then you could take the number of years by month and days

=(TODAY() - Hiredatecolumn@row) / 365

• Options

Unfortunately, it's not giving me the proper data.

From amount of days, how can I convert it to years, months and days in the same formula?

• ✭✭✭✭✭
Options

You could make a column for Year , Month, and Day separately. Lets use 07/06/20 as an example hire date.

you will also want to use the decrease decimal button in the upper left hand corner

So =(TODAY() - Hiredatecolumn@row) / 365 would give you the YEAR column of 2

Then =YEAR@row * 12 would give you the MONTHS of 24

Then =YEAR@row * 365 would give you the days of 730

• Options

I want to achieve something like this :)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!