B

#### Bert

Sheet2. In sheet1, I have a reference to those days. For example in A3 I

have the formula =Sheet2!D3 which displays the correct date. I'd like to

copy the formula to every 7th cell in Column A in Sheet1. What's happening

now is that the copied formula increments by 7 The formula copied into the

cell A10 is "=Sheet2!D10". How can I force it to increment only by 1, so

that it references the dates in Sheet2 correctly?

Thanks

Bert