fiscal year calculation

  • Thread starter Thread starter ml
  • Start date Start date
M

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.
 
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
 
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
 
Back
Top