Converting a formula filed that has year and month (Round to year)

I have a Service Years column that I would like to round in a new formula filed
image

This is what the formula looks like in the Service Years column
image

I would like to have a new field/column that take the year and month and round it up to the year.

Example: (Service Years) 10 years 10 months – (New Field/Column) 11 years

If you want to round to the nearest year

IF(
  {Continuous Service Date},
  ROUND(DATETIME_DIFF(TODAY(), {Continuous Service Date}, "months")/12)
)

^I used TODAY instead of NOW because you are calculating years. You don’t need the formulas to refresh frequently, so using TODAY will be more efficient.

If you want to always round up:

IF(
  {Continuous Service Date},
  ROUNDUP(DATETIME_DIFF(TODAY(), {Continuous Service Date}, "months")/12, 0)
)

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.