Help

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

Topic Labels: Formulas
853 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesus_Yanes
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Reply 1

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)
)