Financial Year Month Number
 

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

Financial Year Month Number
 

Tiffany wrote:
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)

Financial Year Month Number
 

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

"Glenn" wrote:

Tiffany wrote:
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)

Financial Year Month Number
 

On Tue, 20 Jan 2009 14:00:05 -0800, Tiffany
wrote:

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