Date Function

Hi,
I am working for this project where I need to calculate number of months between two dates. For instance, I need to calculate the month between: 00-Jan-1964 and 00-Mar-1966. As you can see we don't have exact dates in them. Most of the excel functions that I found online work when I put exact dates in it. But we don't have any exact dates at our disposal. So could you suggest me any date function or a combination of functions that could help me calculate the number of months between these dates. Any help would be greatly appreciated!Thank you!!

Try

=DATEDIF(DATEVALUE(SUBSTITUTE(A1,"00","01")),DATEVALUE(SUBSTITUTE(B1,"00","01")),"m")

A1 = Start Date

B1=Finish Date

so all dates are 1st of month

Thank you so much for that formula it works!
I was wondering what will be the change in the above mentioned formula if one of the full date is given Let's say if the dates were 14-Jan-1964 and 00-Mar-1966. OR if the dates were 00-Jan-1964 and 14-Mar-1966, Thank you once again for your help!

Or try this ...

=DATEDIF(--SUBSTITUTE(A1,"00-","01-"),--SUBSTITUTE(B1,"00-","01-"),"m")