I would do it by using two separate columns, typing in the two top row
dates, the highlight the area you wish to fill, then Edit Fill Series
Trend..........then when you have the two columns of dates, use a third
helper column with this formula copied down......

=TEXT(A1,"mm/dd/yy")&" to "&TEXT(B1,"mm/dd/yy")

then Copy PasteSpecial Values the column and delete the
others...........
It may be the long way around, but it works..........

Vaya con Dios,
Chuck, CABGx3


"cwwolfdog" wrote in message
...
I am trying to enter the first 7 days of the year in one cell.
ie: A1 - 1/2/05 to 1/8/05
And then I want to drag that down to 53 cells and have it copy in the
following format.
ie: A2 - 1/9/05 to 1/15/05
A3 - 1/16/05 to 1/22/05
etc...
Is this possible?