VBA to fill dates and print

[Pisky]

I have a checklist I want to fill the dates - Monday to sunday and also fill the week ending date too.

I then want to print the sheet for the entire month.

For example, 01/08/2022 -07/08/2022 in the "Mon to Sun" boxes (C3-I3) and then 07/08/2022 in K1. And then have this repeat for each week until it reaches the end of the month - 08/08/2022-14/08/2022 etc etc.

Is this possible with VBA code?

Loss Prevention Checklist.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Checklist							week ending Sunday :
2	Day / Date:		Mon	Tues	Wed	Thurs	Fri	Sat	Sun	COMMENTS :
3
Sheet1