fiscal year calculation

[ml]

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.

 

[tompl]

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

=Datedif(A1, A2, "m")

Tom

 

[Fred Smith]

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

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

Regards,
Fred

 

[Fred Smith]

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