Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
116 1
Showing results for 
Search instead for 
Did you mean: 

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

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

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

  {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:

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