If you drag the fill handle of a date with the right mouse button, a special menu appears option to Fill Weekdays, along with other choices. The right-drag menu that appears offers other options if you're dragging text or numbers.
Mar 25
Excel Tip: Right-Drag Tricks
