Inserting certain dates in a list based off Month

[jbarrick007]

Hello,
I have a schedule list that I would like to get the correct or simplest way of adding the dates to a reoccurring meeting.
In J1 i list the start of the schedule and then the month headers appear: Jan Feb March.

But now in each month section I want to list the dates for Sundays and Thursdays. I started to get close with the intldates but came up short. Obviously I cant just insert the first date and add 7 since some month have 4 and others 5 of the says in a given month.

As a kicker it would be awesome if the monthly list offset with the top line only Sunday if the month started on a Saturday. so that the dates went in order and didnt just the first line show thursday 6th and then sunday 2nd. That might be getting a little fancy.

Host Schedule - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Host and Co-host Schedule								Month Starting:	1/1/2021
2
3	Zoom Meetings
4
5
6	January
7	Mid-Week				Weekend				Assignments		Approved Host
8		Host	Co-Host			Host	Co-Host	0	Ted Walters		Ted Walters
9	1				1			0	Jeff Barrick		Jeff Barrick
10	2				2			0	Jonathan Smith		Jonathan Smith
11	3				3			0	Matt David		Matt David
12	4				4			0	Gary Page
13	5				5			0	Paul Greene
14								0	Owen Rivers
15	February							0	Reggie Schooley
16	Mid-Week				Weekend			0
17		Host	Co-Host			Host	Co-Host	0			Approved Co-Host
18	1				1			0			Gary Page
19	2				2			0			Paul Greene
20	3				3			0			Owen Rivers
21	4				4			0			Reggie Schooley
22	5				5			0
23								0
24	March
25	Mid-Week				Weekend
26		Host	Co-Host			Host	Co-Host
27	1				1
28	2				2
29	3				3
30	4				4
31	5				5
32
Sheet1

Cell Formulas
Range	Formula
A6	A6	=J1
A15	A15	=J1+31
H8:H23	H8	=COUNTIF($B$10:$C$19,I8)
A24	A24	=J1+62

 

[Dave Patton]

Possibly the following help.
N.B. You can post a concise example with the forum's XL2bb. Please show expected results.

T202011b.xlsm
	D
1	31-Oct-20
2	Sun Nov 01, 2020
3	Thu Nov 05, 2020
4	Sun Nov 08, 2020
5	Thu Nov 12, 2020
6	Sun Nov 15, 2020
7	Thu Nov 19, 2020
8	Sun Nov 22, 2020
9
2c

Cell Formulas
Range	Formula
D2:D8	D2	=WORKDAY.INTL(D1,1,"1110110")

 

[jbarrick007]

I apologize I posted the wrong clip.
This shows in the month of Januard what I am trying to produce based off listed 1/1/21 at J1.
I would like to of course have all three months populate the same as January which I manually inserted.

Host Schedule - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Host and Co-host Schedule								Month Starting:	1/1/2021
2
3	Zoom Meetings
4
5
6	January
7	Mid-Week				Weekend				Assignments		Approved Host
8	Date	Host	Co-Host		Date	Host	Co-Host	0	Ted Walters		Ted Walters
9					3-Jan			0	Jeff Barrick		Jeff Barrick
10	7-Jan				10-Jan			0	Jonathan Smith		Jonathan Smith
11	14-Jan				17-Jan			0	Matt David		Matt David
12	21-Jan				24-Jan			0	Gary Page
13	28-Jan				31-Jan			0	Paul Greene
14								0	Owen Rivers
15								0	Reggie Schooley
16	February							0
17	Mid-Week				Weekend			0			Approved Co-Host
18	Date	Host	Co-Host		Date	Host	Co-Host	0			Gary Page
19	1				1			0			Paul Greene
20	2				2			0			Owen Rivers
21	3				3			0			Reggie Schooley
22	4				4			0
23	5				5			0
24
25
26	March
27	Mid-Week				Weekend
28	Date	Host	Co-Host		Date	Host	Co-Host
29	1				1
30	2				2
31	3				3
32	4				4
33	5				5
34
Sheet1

Cell Formulas
Range	Formula
A6	A6	=J1
A16	A16	=J1+31
H8:H23	H8	=COUNTIF($B$10:$C$20,I8)
A26	A26	=J1+62

 

[Dave Patton]

Your post stated "list of dates for Sundays and Thursdays".

Did you try the suggestion?