Number of Months Counts

[Jalal]

Would like to know the function that returns the number of months, for
example to return 20 for the months from Feb-2008 to Sep-2009.

 

[Bernard Liengme]

Have a look at DATEDIF. This is undocumented but Chip tells all at
www.cpearson.com
best wishes

 

[Rick Rothstein \(MVP - VB\)]

And if you weren't aware of the DATEDIF function that Bernard referred you
to, you could always do it the long way...

=12*(YEAR(B10)-YEAR(A10))+MONTH(B10)-MONTH(A10)+1

where it is assumed your begin date is in A1 and your end date is in B1.

Rick

 

[Jalal]

Thanks guys.

And if you weren't aware of the DATEDIF function that Bernard referred you
to, you could always do it the long way...

=12*(YEAR(B10)-YEAR(A10))+MONTH(B10)-MONTH(A10)+1

where it is assumed your begin date is in A1 and your end date is in B1.

Rick