MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autofill query


Posted by Robin on February 07, 2002 3:06 AM

Hi.

Is there any way that I can create an list that will autofill down to give working days of the week only?
Eg Monday through Friday and then (skipping the weekend)the next Monday through Friday.

As in:
4-Feb
5-Feb
6-Feb
7-Feb
8-Feb
11-Feb
12-Feb etc...

Thanks in advance,

Robin


Posted by Mudface on February 07, 2002 3:15 AM

Enter your starting date, then RIGHT-click and drag down till the tip shows your end-date, select the Weekdays option from the pop-up menu. You'll probably have to delete some dates as Excel generally overfills.