The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Dec 06, 2022 07:20 PM
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.
Solved! Go to Solution.
Dec 06, 2022 08:14 PM
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
Dec 06, 2022 08:14 PM
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
Dec 07, 2022 04:33 AM
Thats perfect. I appreciate it greatly.