Rolling Date excluding weekends

[Figjam]

I'm totally unsure what the solution to this is so please if there any suggestions it would be greatly appreciated
I'm trying to have a two week rolling dates, starting on the Monday and continuing until the following Friday, this is fine if static but when the start date is then Tuesday, Wednesday etc the week then inculdes either the Saturday or Sunday. From using =TODAY(), how do I populate the next ten working days without including the weekends?

 

[Smitty]

Welcome to the Board!

Maybe something like this:

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K
1		Start Date	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7	Day 8	Day 9	Day 10
2	Date	7/16/2013	07/17/13	07/18/13	07/19/13	07/22/13	07/23/13	07/24/13	07/25/13	07/26/13	07/29/13
3	Day	Tuesday	Wednesday	Thursday	Friday	Monday	Tuesday	Wednesday	Thursday	Friday	Monday
4	Day #	3	4	5	6	2	3	4	5	6	2
Sheet1

Cell Formulas
Range	Formula
B2	=TODAY()
B3	=TEXT(B2,"dddd")
B4	=WEEKDAY(B2)
C2	=IF((WEEKDAY(B2)+1)=7,B2+3,IF((WEEKDAY(B2)+1)=1,B2+2,B2+1))
C3	=TEXT(C2,"dddd")
C4	=WEEKDAY(C2)
D2	=IF((WEEKDAY(C2)+1)=7,C2+3,IF((WEEKDAY(C2)+1)=1,C2+2,C2+1))
D3	=TEXT(D2,"dddd")
D4	=WEEKDAY(D2)
E2	=IF((WEEKDAY(D2)+1)=7,D2+3,IF((WEEKDAY(D2)+1)=1,D2+2,D2+1))
E3	=TEXT(E2,"dddd")
E4	=WEEKDAY(E2)
F2	=IF((WEEKDAY(E2)+1)=7,E2+3,IF((WEEKDAY(E2)+1)=1,E2+2,E2+1))
F3	=TEXT(F2,"dddd")
F4	=WEEKDAY(F2)
G2	=IF((WEEKDAY(F2)+1)=7,F2+3,IF((WEEKDAY(F2)+1)=1,F2+2,F2+1))
G3	=TEXT(G2,"dddd")
G4	=WEEKDAY(G2)
H2	=IF((WEEKDAY(G2)+1)=7,G2+3,IF((WEEKDAY(G2)+1)=1,G2+2,G2+1))
H3	=TEXT(H2,"dddd")
H4	=WEEKDAY(H2)
I2	=IF((WEEKDAY(H2)+1)=7,H2+3,IF((WEEKDAY(H2)+1)=1,H2+2,H2+1))
I3	=TEXT(I2,"dddd")
I4	=WEEKDAY(I2)
J2	=IF((WEEKDAY(I2)+1)=7,I2+3,IF((WEEKDAY(I2)+1)=1,I2+2,I2+1))
J3	=TEXT(J2,"dddd")
J4	=WEEKDAY(J2)
K2	=IF((WEEKDAY(J2)+1)=7,J2+3,IF((WEEKDAY(J2)+1)=1,J2+2,J2+1))
K3	=TEXT(K2,"dddd")
K4	=WEEKDAY(K2)

HTH,

 

[Figjam]

Spot on, exactly what was needed, many thanks Smitty

Figjam