Financial Year Month Number

[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

 

[Glenn]

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

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

 

[Tiffany]

Thanks
Sorry I posted twice, but I got an error msg saying the first one didn't post

 

[Ron Rosenfeld]

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

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