Help

Re: Years of service formula

Solved
Jump to Solution
606 0
cancel
Showing results for 
Search instead for 
Did you mean: 
cvlawson
4 - Data Explorer
4 - Data Explorer

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
TheTimeSavingCo
17 - Neptune
17 - Neptune

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
TheTimeSavingCo
17 - Neptune
17 - Neptune

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.