Calculate number of days and years from start date

Leann Gibson

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

Leann Gibson

That worked perfectly, thank you!!

Kaveri Vipat

Hi Leann Gibson, 

You can try the formula in the Tenure column. 

=([Today1]@row - [Start Date]@row) / 365 

I hope this works for you!

Leann Gibson

That worked perfectly, thank you!!