3 days per week.

[serge]

Hi,
I'm looking for a formula that will repeat those 3 days week MON, WED, SAT in a loop.
I start in B6 with a MON putting the formula in B7 should be a WED then SAT, etc...
Thank you.

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2
3
4
5
6		Mon
7		Wed
8		Sat
9		Mon
10		Wed
11		Sat
12		Mon
13		Wed
14		Sat
15		Mon
16		Wed
17		Sat
18		Mon
19		Wed
20		Sat
Data

Cell Formulas
Range	Formula
B7:B20	B7	=CHOOSE(MOD(ROWS(B$7:B7),3)+1,"Mon","Wed","Sat")

 

[serge]

Perfect, Thank you so much Fluff really appreciate the help.

 

[Fluff]

You're welcome & thanks for the feedback.