View Single Post
  #1   Report Post  
dstock
 
Posts: n/a
Default 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.


--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=380192