Help

Calculate the years worked based on career start date

Topic Labels: Formulas
Solved
Jump to Solution
1839 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

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"))
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Justin that worked thanks!