Hello,

I want to make the duration of two dates closest to years in months, what formula would I use?

for example, I have a start date/end date of
9/1/21 8/30/26

when I do DATEIF in months I get 59, however, I want it to round up to the nearest 12 month in years, so for example, I want it to be 60 months.

what would I add to my formula or how would I write it? Let's say start date is A1 and end date is B1.

Basically, I have several dates and need them all to be as close to 12 x x as possible.