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. [TABLE="width: 500"]
<tbody>[TR]
[TD]date battery was installed[/TD]
[TD]current date[/TD]
[TD]=DATEDIF(A2,B2,"M")[/TD]
[/TR]
[TR]
[TD]9/25/2015[/TD]
[TD]9/26/2017[/TD]
[TD]24(formula answer)[/TD]
[/TR]
[TR]
[TD]9/25/2015[/TD]
[TD]9/26/2017[/TD]
[TD]25(answer I want)[/TD]
[/TR]
</tbody>[/TABLE]

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