Weekly dates with split across weeks with two months

[Brisneylander]

Hi, I have a budgeting spreadsheet with weekly dates across the top. Where a month ends part way through a week I need to splt the dates so that the next date is the start of the next month. Above those dates is the number of days in the week for that month. Looking for how to do this with a formulae and not manually....

FWB-Acedemic Integrity.xlsm
	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
3				3	2				4	1									2	3
4	8/01/2024	15/01/2024	22/01/2024	29/01/2024	1/02/2024	5/02/2024	12/02/2024	19/02/2024	26/02/2024	1/03/2024	4/03/2024	11/03/2024	18/03/2024	25/03/2024	1/04/2024	8/04/2024	15/04/2024	22/04/2024	29/04/2024	1/05/2024	6/05/2024
Financials

 

[Peter_SSs]

Welcome to the MrExcel board!

Looking for how to do this with a formulae

Do you mean
- row 3
- row 4
- both?

For the sequence in your post above, can you also show us (again with XL2BB) what happens at the end of May and beginning of June where I believe there is no "split week"?