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.

Neale Blackwood is a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services, as well as advanced Excel training. You can email Neale at nblackwood@accessanalytic.com.au