Autofill: Need to autofill one week block, (5) weekday only into cells.

[dstock]

What I need to do I'm sure is simple but I can't get the formula/format
correct. What I want to do is be able to autofill weekday only, one
week blocks at a time. For example, I would like to be able to enter
6/20/05 - 6/24/05, select the cell and then drag it to x amount of cells
to have it autofill the same format. So 4 cells would look like this:

6/20/05-6/24/05
6/27/05-7/1/05
7/4/05-7/8/05
7/11/05-7/15/05

Non-business weekdays aren't a problem, I just need the 5 day, weekday,
one week blocks to be able to autofill. Any help is appreciated, thanks.

 

[Dave Peterson]

How about using a couple of columns?

I put this in A1:
6/20/2005
I put this in A2:
=a1+7

I put this in B1:
=TEXT(A1,"mm/dd/yy")&"-"&TEXT(A1+4,"mm/dd/yy")
And dragged down to B2.

Then I selected A2:B2 and dragged down as far as I wanted.

Then I could select column B and
edit|copy
edit|paste special|Values
and
delete column A
(if I wanted.)

(Actually, I think I'd just hide column A so I could use it later.)