« Top Ten Articles | Main | Paste Special IV: Inserting rows »
October 18, 2005
Creating A Series Of Workdays
To create a series of dates in a range, with just weekdays (Monday through Fridays), you first enter your starting date in a cell (B2, in the example below), and then enter the following formula in the cell below that cell.=IF(OR(WEEKDAY(B2+1)=1;WEEKDAY(A4+1)=7);B2+3;B2+1)
Then use the Fill Down utility to fill out your entire series of dates.
The formula to display the day of the week we have already met...
=CHOOSE(WEEKDAY(B2);"Sun";"Mon";"Tue";"Wed";"Thu";"Fri";"Sat")
Posted by Dave at October 18, 2005 08:46 PM