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?