Week days formula.

[serge]

I'm looking for 2 formulas that will return designated day, see example please, Thank you.

Which formula should I put starting B9 scrolling down, to return those 2 days FRI, TUE, FRI, TUE, FRI, TUE Etc…

and the same for in column D, but returning 3 days starting in cell D9, returning WED, SAT, MON, WED, SAT, Etc…

Thank you.

 

[awoohaw]

How about:

Book1
	E	F
3	TUES	MON
4	FRI	WED
5	TUES	SAT
6	FRI	MON
7	TUES	WED
8	FRI	SAT
9	TUES	MON
10	FRI	WED
11	TUES	SAT
12	FRI	MON
Sheet4

Cell Formulas
Range	Formula
E3:E12	E3	=IF(ISODD(ROW()),"TUES","FRI")
F3:F12	F3	=IF(MOD(ROW(),3)=0,"MON",IF(MOD(ROW(),3)=1,"WED","SAT"))

 

[Phuoc]

Or try this

Book1
	E	F
3	TUE	MON
4	FRI	WED
5	TUE	SAT
6	FRI	MON
7	TUE	WED
8	FRI	SAT
9	TUE	MON
10	FRI	WED
11	TUE	SAT
12	FRI	MON
Sheet1

Cell Formulas
Range	Formula
E3:E12	E3	=IF(E2="TUE","FRI","TUE")
F3:F12	F3	=IF(F2="MON","WED",IF(F2="WED","SAT","MON"))

 

[serge]

Thank you to both of you it works very well, I really appreciate your help, Thank you so much.
Serge.

 

[Rick Rothstein]

While I am not sure either of these are better than Phuoc's formulas (especially the second one), here is another way to write the formula for cell B9...

=SUBSTITUTE("TUEFRI",B8,"")

And here is an alternative for cell D9...

=MID("MONWEDSATMON",FIND(D8,"MONWEDSATMON")+3,3)

 

[Phuoc]

Another way:

Book1
	E	F
3	MON	MON
4	TUE	WED
5	MON	SAT
6	TUE	MON
7	MON	WED
8	TUE	SAT
Sheet1

Cell Formulas
Range	Formula
E3:E8	E3	=CHOOSE((A2="MON")+1,"MON","TUE")
F3:F8	F3	=CHOOSE((F2="MON")+2*(F2="WED")+1,"MON","WED","SAT")

 

[serge]

Thank you Rick and Phuoc.