Fill Down Formula Pattern

[no shoe]

I need to continue filling down the data on the right by day of the week, however the fill handle is not adjusting the formulas the way that I would like. Any help?

******** ******************** ************************************************************************>

Microsoft Excel - Book2 ___Running: 11.0 : OS = Windows Windows 2000

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout

D2J2K2L2M2D3G3H3I3J3K3L3M3D4G4D5G5D6D7D8D9D10D11D12D13 =

A

B

C

D

E

F

G

H

I

J

K

L

M

1

*

OBC

cc

*

*

*

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

2

Wed*01/01

696

794

87.7%

*

*

*

*

*

87.7%

74.3%

70.7%

76.0%

3

Thu*01/02

1538

2,071

74.3%

*

*

85.9%

78.3%

66.9%

70.5%

74.8%

74.9%

90.7%

4

Fri*01/03

1332

1,883

70.7%

*

*

86.6%

*

*

*

*

*

*

5

Sat*01/04

713

938

76.0%

*

*

90.2%

*

*

*

*

*

*

6

Sun*01/05

633

737

85.9%

*

*

*

*

*

*

*

*

*

7

Mon*01/06

1570

2,006

78.3%

*

*

*

*

*

*

*

*

*

8

Tue*01/07

1309

1,957

66.9%

*

*

*

*

*

*

*

*

*

9

Wed*01/08

1255

1,781

70.5%

*

*

*

*

*

*

*

*

*

10

Thu*01/09

1362

1,822

74.8%

*

*

*

*

*

*

*

*

*

11

Fri*01/10

1245

1,663

74.9%

*

*

*

*

*

*

*

*

*

12

Sat*01/11

732

807

90.7%

*

*

*

*

*

*

*

*

*

13

Sun*01/12

562

649

86.6%

*

*

*

*

*

*

*

*

*

Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.