Thanks:  0
Likes:  0

# Thread: Shorten this formula, if it can be done

1. 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

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

3. F2 is a date
A6 is where my timesheet line begin

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

5. 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

6. 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")

7. =TEXT(\$F\$2,"DDD")

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•