Creating a calendar from a data set.

[Erald]

Hello,

Would I be able to create a calendar from a data set as shown in the attachment? I would like to be able to change the date on the data set and the name associated with it to appear in the calendar. (Note that I have put the names on the calendar manually, based on the data set information). Thank you in advance for your help!

Regards,
Erald

 

[JamesCanale]

I reorganized the way the 'days' are kept - it makes it easier if you keep it like data in a neat table.

MrExcelPlayground22.xlsx
	A	B	C	D	E	F	G	H	I	J
1				June 2024
2				Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
3	Name	Day								01
4	DHHS P	6/17/2024
5	DHHS P	6/24/2024
6	DHHS P	6/25/2024
7	TITLE IV	6/10/2024		02	03	04	05	06	07	08
8	TITLE IV	6/17/2024
9	TITLE IV	6/24/2024
10	NSF	6/12/2024
11	NSF	6/24/2024		09	10	11	12	13	14	15
12	NSF	6/25/2024			TITLE IV	Education	NSF
13	Education	6/11/2024
14	Education	6/18/2024
15	Education	6/25/2024		16	17	18	19	20	21	22
16					DHHS P	Education
17					TITLE IV
18
19				23	24	25	26	27	28	29
20					DHHS P	DHHS P
21					TITLE IV	NSF
22					NSF	Education
23				30
24
25
26
Sheet19

Cell Formulas
Range	Formula
D3	D3	=IF(WEEKDAY($D$1)=1,$D$1,"")
E3	E3	=IF(WEEKDAY($D$1)=2,$D$1,IF(D3<>"",D3+1,""))
F3	F3	=IF(WEEKDAY($D$1)=3,$D$1,IF(E3<>"",E3+1,""))
G3	G3	=IF(WEEKDAY($D$1)=4,$D$1,IF(F3<>"",F3+1,""))
H3	H3	=IF(WEEKDAY($D$1)=5,$D$1,IF(G3<>"",G3+1,""))
I3	I3	=IF(WEEKDAY($D$1)=6,$D$1,IF(H3<>"",H3+1,""))
J3	J3	=IF(WEEKDAY($D$1)=7,$D$1,IF(I3<>"",I3+1,""))
D4:J4,D24:J24,E20:F22,D20,G20:J20,E16:E17,D16,F16:J16,D12:J12,D8:J8	D4	=IFERROR(IF(D3="","",FILTER(Table8[Name],Table8[Day]=D3)),"")
D7,D15,D11	D7	=J3+1
E7:J7,E15:J15,E11:J11	E7	=D7+1
D19	D19	=IF(MONTH(J15+1)=MONTH($D$1),J15+1,"")
E19:J19,E23:J23	E19	=IFERROR(IF(MONTH(D19+1)=MONTH($D$1),D19+1,""),"")
D23	D23	=IFERROR(IF(MONTH(J19+1)=MONTH($D$1),J19+1,""),"")