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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging Fiscal / Calendar year Fuel 11
Find the position of a date 6
weeks in a month 1
Fiscal Month Formula 3
Fiscal Year Formula 7
Date range help 2
Transform calendarized data 4
My own fiscal year 3

Back
Top