month between the days

[Arvind1977]

hi ,

can any one please help me to calculate the number of month between two dates in 365 date format.

like for example

15-Mar-11 31-Mar-12
01-Mar-11 31-Mar-12 = 13
01-Oct-10 30-Apr-11 =7
15-Mar-11 14-Mar-12
01-Sep-10 31-Aug-11
15-Mar-11 31-Mar-12
01-Mar-11 31-Mar-12
01-Mar-11 31-Mar-12
16-Nov-10 30-Nov-11
01-Mar-11 31-Mar-12
01-Mar-11 31-Mar-12
01-Mar-11 31-Mar-12
01-Jan-11 31-Dec-11
01-Jan-11 31-Dec-11
01-Jan-11 31-Dec-11
01-Jul-10 30-Jun-11
01-Apr-10 31-Mar-12
01-Sep-10 30-Apr-11
01-Apr-10 31-Mar-11

Thanks Arvind

 

[VoG]

Try

=DATEDIF(A1,B1,"m")

 

[Arvind1977]

thanks alot .



it works