Financial Year Month Number

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
 
G

Glenn

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)
 
T

Tiffany

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

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