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

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.

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.)

dstock wrote:
>
> 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.
>
> --
> dstock
> ------------------------------------------------------------------------
> dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
> View this thread: http://www.excelforum.com/showthread...hreadid=380192

--

Dave Peterson