New to Smartsheet formulas

Christine Speight

I am trying to calculate "years of experience" based on the certification start date 1/1/2015 through 02/21/21 certification expiration date. The start date is static and the expiration will change every 2 years. I clearly am not using the correct words in the help section to get my answer. Please help. Thank you.

Mark Cronk

Hi @Christine Speight ,

To calculate the number of years between 2 date use this formula in your "Years of Experience" column: =([End Date]@row - [Start Date]@row) / 365.25

Replace my [end date] with the name of the column with your certification end date. Replace my [start date] with the name of the column with your certification start date.

If you're looking for how many years of experience they have as of now the formula would be =(Today() - [Start Date]@row) / 365.25

Work?

Mark

Mark Cronk

Hi @Christine Speight ,

To calculate the number of years between 2 date use this formula in your "Years of Experience" column: =([End Date]@row - [Start Date]@row) / 365.25

Replace my [end date] with the name of the column with your certification end date. Replace my [start date] with the name of the column with your certification start date.

If you're looking for how many years of experience they have as of now the formula would be =(Today() - [Start Date]@row) / 365.25

Work?

Mark

Christine Speight

Hi @Mark Cronk,

Thank you for such an immediate response. YAY!!! It worked. My team is tracking another team with over 2000 people and this is a regulatory issue. You have saved us hours of manual calculation.

Thank you, again.

Christine

Mark Cronk

Happy to help. You saved your team hours by being willing to reach out to the Smartsheet Community. Everything is easier when we work together.

Be well,

Mark