Fill dates with weekdays/workdays only

[DJ Bjorklund]

How do I fill a column's cells with a year's worth of weekdays only?
TIA

 

[JE McGimpsey]

Enter the first date. Right-click the fill handle in the lower right
corner of the cell and drag down about 270 rows. Choose Fill Weekdays
from the menu that pops up when you release the mouse.

 

[Gilbert De Ceulaer]

Set 1ste weekday in H29 (in 2005 : "03/01/2005")
then in h30->h(as much as you like):
=IF(WEEKDAY(H29;2)=6;H29+3;IF(WEEKDAY(H29;2)=7;H29+2;H29+1))
OK ?
Gilbert