Financial Year Month Number

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

Hi there,

I'm trying to find a formula that returns the month in the financial year,
eg October is month no 4, but the month() function returns the month no in
the calendar year.

Thanks in advance
 
Tiffany said:
Hi there,

I'm trying to find a formula that returns the month in the financial year,
eg October is month no 4, but the month() function returns the month no in
the calendar year.

Thanks in advance
Click to expand...


=CHOOSE(MONTH(A1),7,8,9,10,11,12,1,2,3,4,5,6)
 
Hi there,

I'm trying to find a formula that returns the month in the financial year,
eg October is month no 4, but the month() function returns the month no in
the calendar year.

Thanks in advance
Click to expand...

IF October is 4, then with a date in G1:

=MOD(MONTH(G1)-7,12)+1

In general:

=MOD(MONTH(G1)-month_1_number,12)+1
--ron
 
Back
Top