Dragging weekdays only

Right click and drag

By Neale Blackwood

If you need to populate only weekdays when you drag a date cell with the fill handle (the cross at the bottom right corner of cell/range) then drag the fill handle with the right mouse button. When you release the button there will be a Fill Weekdays option.