calculating difference in months between 2 dates

Experts,

I am trying to calculate the difference (in months) between two dates INCLUSIVE of both dates. I have a formula, but it doesn't work properly all the time.

Here is when it works properly:

DATE 1: 8/31/07 (Cell G49)
DATE 2: 12/31/10 (Cell I49)
FORMULA: =+DATEDIF(G49,I49,"m")+1
RESULT: 41 months *CORRECT*

Here is when it doesn't work properly:

DATE 1: 8/31/07 (Cell G49)
DATE 2: 2/28/11 (Cell I49)
FORMULA: =+DATEDIF(G49,I49,"m")+1
RESULT: 42 months *INCORRECT* =>should be 43 months

I can't figure this out. Any help would be much appreciated. Thanks!

See if this works:

=DATEDIF(G49,I49,"m")+IF(DAY(G49)>DAY(I49),2,1)

HTH

Jason

Jason,

I believe your formula works. Thank you very much for the assistance!

No problem.