Sequential numbers that reset when one number is reached, then reset again for another number

[uber2au]

I dont know how to ask the question,
but the problem is I am working with various rosters, for example

Rosters	Weeks	Days	Days	Days Paid	Days
Name	Cycle	On	Off	Not Worked	Total
1	1.00	5	2	1	7
2	2.00	10	4	1	14
3	3.00	14	7	1	21
4	4.00	21	7	2	28
5	5.29	28	9	1	37
6	2.00	7	7	1	14
7	6.00	28	14	1	42

I want to create a series of columns
Month l Day l Date l Cycle Day l and so on
in cycle day column i would like to automatically populate the cycle days, for example if I was to use Cycle 4, it is a 21 days on and 7 days off.
the column would be populated thus;

Jan l Wednesday l 1/01/2020 l 1 l
Jan l Thursday l 2/01/2020 l 2 l
Jan l Friday l 3/01/2020 l 3 l

the cycle days would progress until they reached 21 then change to 1 and increase to 7 then change again to 1 and increase to 21 and so on.

Thank you for any suggestions

Ken.

 

[Peter_SSs]

Not necessarily, just want to get the right number of "on"'s and "off"'s

So, try this slight modification.

uber2au 1.xlsm
	F	G	H	I	J
23			1	4	3
24
25
26
27	on/off
28	on
29	on
30	on
31	on
32	off
33	off
34	off
35	on
36	on
37	on
38	on
39	off
40	off
41	off
42	on
43	on
44	on
45	on
46	off
47	off
48	off
49	on
50	on
51	on
52	on
53	off
Sheet1

Cell Formulas
Range	Formula
F28:F53	F28	=IF(MOD(ROWS(F$28:F28)-1,I$23+J$23)<I$23,"on","off")

 

[uber2au]

Thank you Peter_SSs
This one did the trick.
I had tried the "-1" before but with ROW not Rows. thanks
Ken

 

[Peter_SSs]

Thank you Peter_SSs
This one did the trick.

You're welcome. Glad it helped.

but with ROW not Rows

Using ROW instead of ROWS in this sort of formula is always risky. Even if you get the formula to produce the result(s) you want, generally if later somebody decides to insert new rows at the top of the sheet, the formula will generally then return incorrect results & sometimes that is not obvious so you end up unknowingly using incorrect data.