- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 07, 2022 04:33 AM
Thats perfect. I appreciate it greatly.
