Calculate the years worked based on career start date

[Lisa_Gervais]

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.

[Justin_Barrett]

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

DATEADD(Date, 35, "years")

[Lisa_Gervais]

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

[Jeremy_Oglesby]

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

[Justin_Barrett]

Or wrap the YEAR function around the rest:

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

[Lisa_Gervais · Accepted solution]

Hi Justin that worked thanks!