Put this in A3 of Sheet1:

=INDIRECT("Sheet2!D"&INT((ROW(A3)+4)/7)+2)

and then copy it to A10, A17, A24 etc.

Another way would be to enter your original formula and copy down
contiguous cells, then insert 6 new rows between each of the rows with
formulae in.

Hope this helps.

Pete

On Mar 15, 12:39*am, "Bert" wrote:
I have a list of dates (consecutive weekdays - some holidays) in Column D in
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