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.

In article ,
DJ Bjorklund wrote:

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