Hi,

Use another column and use Excel's own date calculation capabilities

In A1, put 1/2
In A2, put =A1+7
drag down as you need

In B1, the following formula:
=TEXT(A1,"m/d to ") & TEXT(A1+6,"m/d")
drag down as you need

The additional column (A) enables you to carry some real dates calculations,
should you need to.

Regards,

Daniel M.

"cwwolfdog" wrote in message
...
I have a bunch of different worksheets that all need dates in 7 day intervals.

For example cell A1 has 1/2 to 1/8 and I want to drag the square at the
bottom right of the cell down to cell A2 and I want it to say 1/9 to 1/15.

Is this possible?