Fill only Tuesday's and Thursday's

[FryGirl]

In this table, I would like to fill down the pattern, Tuesday followed by Thursday, where column A shows a 1. I would like to start with 5-Jan.

bibles.xlsm
	A	B
1
2
3
4	1	5-Jan-21
5
6
7	1	7-Jan-21
8
9
10	1	12-Jan-21
11
12	1	14-Jan-21
13
14	1	19-Jan-21
15
16
17	1	21-Jan-21
18
19
20	1	26-Jan-21
21
22	1	28-Jan-21
23
24	1	2-Feb-21
25
26	1	4-Feb-21
27
28	1	9-Feb-21
29
30
31
32	1	11-Feb-21
Sheet2

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B
1
2
3
4	1	05/01/2021
5
6
7	1	07/01/2021
8
9
10	1	12/01/2021
11
12	1	14/01/2021
13
14	1	19/01/2021
15
16
17	1	21/01/2021
18
19
20	1	26/01/2021
21
22	1	28/01/2021
23
24	1	02/02/2021
25
26	1	04/02/2021
27
28	1	09/02/2021
29
30
31
32	1	11/02/2021
List

Cell Formulas
Range	Formula
B2:B32	B2	=IF(A2=1,WORKDAY.INTL("04/01/2021",SUM(A$2:A2),"1010111"),"")

 

[FryGirl]

This works great and will save a considerable amount of time. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.