Our fiscal year runs from Apr '09 to Mar '10. I need to set up a formula to
return the # of months base on start month and end month. For example:

April 09 to Jan 10 returns 11 months. Any solution. Thank you in advance.

If the first date is in cell A1 and the second date is in cell A2 use this
formula:

=Datedif(A1, A2, "m")

Tom

Apr 09 to Jan 10 is 10 months, not 11.

=month(b1)-month(a1)+1+(month(b1)<month(a1))*12

Regards,
Fred

"ml" wrote in message
...
Our fiscal year runs from Apr '09 to Mar '10. I need to set up a formula
to
return the # of months base on start month and end month. For example:

April 09 to Jan 10 returns 11 months. Any solution. Thank you in
advance.

You need to add 1 to this calculation, as the OP wants both the start month
and the end month included in the range.

Regards,
Fred

"tompl" wrote in message
...
If the first date is in cell A1 and the second date is in cell A2 use this
formula:

=Datedif(A1, A2, "m")

Tom