# New to Smartsheet formulas

Options

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.

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

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

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!