series of dates, step by 1, Mon-Thurs only, for 2007

L

Lisa Hetherington

I would like to have all the dates I'm going to work from Jan 29/07 to Dec
31/07, leaving out all Fri, Sat and Sun dates.

I'm not sure how to do this.

Can someone help me please??
Thanks!!

....Lisa, using Excel 2003
 
H

Harlan Grove

Lisa Hetherington said:
I would like to have all the dates I'm going to work from Jan 29/07 to Dec
31/07, leaving out all Fri, Sat and Sun dates.
Click to expand...
....

Enter Jan 29 in cell A1, enter the following formula in A2,

=A1+IF(WEEKDAY(A1,2)=4,4,1)

and fill A2 down as far as needed.
 
L

Lisa Hetherington

Perfect!!
Thank you.

....Lisa
Harlan Grove said:
...

Enter Jan 29 in cell A1, enter the following formula in A2,

=A1+IF(WEEKDAY(A1,2)=4,4,1)

and fill A2 down as far as needed.
Click to expand...
 
Top