Calculate number of days and years from start date


I need to see how long staff have been with us, their tenure. I need this for any given dates, meaning "today". I have the start date, how do I get the days from that in years and days?

Example: Start date is 06/01/2020, today is 08/23/2023 so the Tenure should be 3 years, 2 months, 22 days. I would take 3.2


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!