fiscal year calculation
 

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.

fiscal year calculation
 

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

=Datedif(A1, A2, "m")

Tom

fiscal year calculation
 

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.

fiscal year calculation
 

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