In fill series date : I want to work on weekdays. I want weekly off as
Thursday

If you want to fill a series of dates and exclude Thursdays:

Enter the starting date in your first cell, assume A1:

A1 = 7/1/2008

Enter this formula in A2 and copy down as needed:

=A1+CHOOSE(WEEKDAY(A1),1,1,1,2,1,1,1)

--
Biff
Microsoft Excel MVP


"Porwal P K" <Porwal P wrote in message
...
In fill series date : I want to work on weekdays. I want weekly off as
Thursday