Please help. How do I round to the nearest month?

[zeeworld]

Hello,

I need the cell to round to the nearest month. I have attached the file. Any help is appreciated. Thanks

 

[Peter Bartholomew]

I do not agree with your example. The dates are little more than a month apart.

= LET(
  months, DATEDIF(JoiningDate, LeavingDate, "m" ),
  days,   DATEDIF(JoiningDate, LeavingDate, "md"),
  ROUND(months + days/30, 0) )


= ROUND(DATEDIF(JoiningDate, LeavingDate, "m") + DATEDIF(JoiningDate, LeavingDate, "md")/30, 0)

The concept of rounding is months is not precisely defined, given that 15days may be more or less than half a month, depending on the length of the month. The first formula using the LET function explains the calculation, but the second works without requiring MS365.

 

[Excel Wizard]

Please try
=ROUND(YEARFRAC(A2,B2)*12,)
or if you really need 2 months
=ROUNDUP(YEARFRAC(A2,B2)*12,)

 

[zeeworld]

Thank you both!