Number Of Months Between Two Dates

  • Hi


    I need to calculate number of months between two dates. In the attached I use formula =MONTH(B2)-MONTH(A2). This is working for those lines where the dates are within the same year. If one date is in 2007 and the other in 2008, than the formula gives negative result.


    Can somebody help? Thanks in advance!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!