Months between two dates

[Tentonhammer69]

I am creating a pro-rated battery calculator and I need a formula to show the number of months between two dates were if it is 24 months and one day it would show as 25.

date battery was installed	current date	=DATEDIF(A2,B2,"M")
9/25/2015	9/26/2017	24(formula answer)
9/25/2015	9/26/2017	25(answer I want)

<tbody>
</tbody>

According to the warranty company that battery is in the first day of the 25th month and it gets moved into the 25-32 month pro-rated period. I would need the formula to see that its 24 months and one day and round it up to 25 months. I hope I explained this clearly.

 

[mart37]

Maybe: =DATEDIF(A2,B2,"M")+IF(DATEDIF(A2,B2,"MD")>0,1,0)

 

[Joe4]

Is this an Access or Excel question?
I ask because you posted the question in the Access forum, but the formula you posted looks like an Excel one.

 

[Tentonhammer69]

That worked thanks and sorry it was meant for excel