Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate the years worked based on career start date

Topic Labels: Formulas
Solved
Jump to Solution
937 5
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m looking to estimate a person’s retirement date based on their career start date, this would be using the assumption that they would work 35 years following their first job.

1 Solution

Accepted Solutions

Hi Justin that worked thanks!

See Solution in Thread

5 Replies 5

This should do it (replace Date with the name of the field that has the person’s career start date):

DATEADD(Date, 35, "years")

Thanks Justin! is it possible to just get the year returned rather than the day/month and time stamp?

DATETIME_FORMAT(
   DATEADD(Date, 35, "years"),
   YYYY
)

Or wrap the YEAR function around the rest:

YEAR(DATEADD(Date, 35, "years"))

Hi Justin that worked thanks!