Need date formula for workdays (Mon-Sat)

[mcmdm50]

Using Excel 2003, I have a spreadsheet with Column B listing workdays (Mon;Tue;Wed;Thur;Fri;Sat) five times and ending with an additional Mon.
I need help a formula that, after entering the 1<SUP>st</SUP> day of the month (ie 3/1), the remaining dates calculate in column C with the corresponding days and after the last date of the month leave the rest of the dates blank. Is that possible or would the manual entry of the 1<SUP>st</SUP> day erase the formula and prevent future use of the spreadsheet?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I would like to be able to reuse the spreadsheet and just change the starting date each month.<o></o>
Thanks,<o></o>

 

[konew1]

Try this =IF(WEEKDAY(B1,1)< 7,B1+1,B1+2)
Put your first date in B1, this formula in B2 and copy down

 

[AlphaFrog]

<br />

Book1
	B	C	D
1	Thursday	3/1/2012	<--First Date
2	Friday	3/2/2012
3	Saturday	3/3/2012
4	Monday	3/5/2012
5	Tuesday	3/6/2012
6	Wednesday	3/7/2012
7	Thursday	3/8/2012
8	Friday	3/9/2012
9	Saturday	3/10/2012
10	Monday	3/12/2012
11	Tuesday	3/13/2012
12	Wednesday	3/14/2012
13	Thursday	3/15/2012
14	Friday	3/16/2012
15	Saturday	3/17/2012
16	Monday	3/19/2012
17	Tuesday	3/20/2012
18	Wednesday	3/21/2012
19	Thursday	3/22/2012
20	Friday	3/23/2012
21	Saturday	3/24/2012
22	Monday	3/26/2012
23	Tuesday	3/27/2012
24	Wednesday	3/28/2012
25	Thursday	3/29/2012
26	Friday	3/30/2012
27	Saturday	3/31/2012
28
29
30
Sheet1

Cell Formulas
Range	Formula
B1	=IF(C1="","",TEXT(C1,"dddd"))
C2	=C1+1+(WEEKDAY(C1+1)=1)
C24	=IF(C23="","",IF(MONTH($C$1)<>MONTH(C23+1+(WEEKDAY(C23+1)=1)),"",C23+1+(WEEKDAY(C23+1)=1)))

Copy the B1 formula down to B30
Copy the C2 formula down to C23
Copy the C24 formula down to C30

Enter the start date in C1 and the formulas should calculate the rest.

 

[mcmdm50]

This worked remarkably well.
Thank you so much.