Skip to main content

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... 

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

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. 

Reply


Terms & Conditions