FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,362
- Office Version
- 365
- 2016
- Platform
- Windows
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 |