Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
INDIRECT Function and Autofill | Excel Worksheet Functions | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
first week of year - according to european standard | Excel Worksheet Functions |