Thread: Extending a series of weekday only dates

Hi
In Excel 2003 (SP3) I have entered three weeks worth of consecutive weekday only dates, selected and dragged to extend the series - but the extended dates start again at the first date in my entered series.
I want to enter drag to create a years worth of weekday only dates.
Any suggestions please ?

Assuming you're starting in cell A1 and dragging the dates downward...

In cell A1 enter the start date.

In cell A2 enter =IF(WEEKDAY(A1,2)=5,A1+3,A1+1)

Drag that formula down (you can use Paste Special|Values to replace the formula with the values afterwards, if you want)

Andrew thank you - you're a gem !