SImple INDEX returning #Ref

[Rocky0201]

Hi,

My range:

F3 = Monday
F4 = Tuesday
.
.
F9 = Sunday

The formula's I tried:

=INDEX(F3:F9,3,6) returns #Ref
=INDEX(F3:F9,ROWS(3),COLUMNS(6)) returns Monday (it's what I was expecting at intersection 3, 6)
=INDEX(F3:F9,ROWS(4),COLUMNS(6)) returns Monday. Expecting Tuesday at intersection 4, 6

My ultimate goal:

In cell A4 I have a date (5/31/2011). In range F3:F9 I have Monday, Tuesday, etc...

I tried =INDEX(F3:F9,ROWS(Weekday(A4,2)),COLUMNS(6)) returns Monday, expecting Tuesday.

Thanks for the help...

 

[Rocky0201]

Never mind... I was able to figure it out.

=INDEX(F3:F9,(WEEKDAY(A4,2)),COLUMNS(6))

Works fine...