Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Years of service formula

Solved
Jump to Solution
170 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I am new to Airtable, but I cannot find a simple formula to calculate years of service for employees from the start date. I can get it to calculate years, but would like to see it in decimal format. For 8 1/2 years I would like to see 8.50. I am currently using the below...Adding the "months", did not do anything different.

 

DATETIME_DIFF(TODAY(),{Start date},'years', "months")
 
Any help is appreciated... 
1 Solution

Accepted Solutions

Hmm, what if you did:

DATETIME_DIFF(TODAY(),{Start date},'months') / 12

And changed the output of the field to be a decimal? That would give you 8.5 like you want I reckon

See Solution in Thread

2 Replies 2

Hmm, what if you did:

DATETIME_DIFF(TODAY(),{Start date},'months') / 12

And changed the output of the field to be a decimal? That would give you 8.5 like you want I reckon

Thats perfect. I appreciate it greatly.