Shorten this formula, if it can be done

[TiggerToo]

Can anyone write a shorter formula, and can you also write me a formula using a lookup table for the formula below. This formula goes in 28 line.

=IF(OR($A6=$F$2,$A6=$F$2+7),"Sun",
IF(OR($A6=$F$2+1,$A6=$F$2+8),"Mon",
IF(OR($A6=$F$2+2,$A6=$F$2+9),"Tue",
IF(OR($A6=$F$2+3,$A6=$F$2+10),"Wed",
IF(OR($A6=$F$2+4,$A6=$F$2+11),"Thu",
IF(OR($A6=$F$2+5,$A6=$F$2+12),"Fri",
IF(OR($A6=$F$2+6,$A6=$F$2+13),"Sat","")))))))

Thank

 

[Aladin Akyurek]

What kind of data house A6 and F2: date, number, etc.? And, what is the purpose?

 

[TiggerToo]

F2 is a date
A6 is where my timesheet line begin

 

[TiggerToo]

F2 is a date
A6 is where my timesheet line begin
and A33 is where it end

 

[TiggerToo]

Al,
I will send you a copy of the sheets need to help me figure out what I am trying to accomplish.

Thanks again,
A long winded Aircraft Mechanic,
Walter
Never Stop Learning

 

[Mark W.]

On 2002-04-20 05:08, TiggerToo wrote:
Can anyone write a shorter formula, and can you also write me a formula using a lookup table for the formula below. This formula goes in 28 line.

=IF(OR($A6=$F$2,$A6=$F$2+7),"Sun",
IF(OR($A6=$F$2+1,$A6=$F$2+8),"Mon",
IF(OR($A6=$F$2+2,$A6=$F$2+9),"Tue",
IF(OR($A6=$F$2+3,$A6=$F$2+10),"Wed",
IF(OR($A6=$F$2+4,$A6=$F$2+11),"Thu",
IF(OR($A6=$F$2+5,$A6=$F$2+12),"Fri",
IF(OR($A6=$F$2+6,$A6=$F$2+13),"Sat","")))))))

Thank

=CHOOSE(MOD($F$2-$A$2,7)+1,"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

 

[HOTDOG]

=TEXT($F$2,"DDD")