Divide Current Month into weeks

[davids4500]

I have in A4 (=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)), and i need a formula that will take this information and instead of showing just the month, show each week of the that month so sales figures appear in a weekly format instead of just one amount for the month. I would like the weeks information to appear as per image attached. When the month changes to a new month, then the week information will change.

 

[Sergius]

Hello!
And why do you have 4 weeks, if there are five or six of them? It all depends on how to count them.

 

[davids4500]

Hello!
And why do you have 4 weeks, if there are five or six of them? It all depends on how to count them.

Dear Sergius.
Correct and September is a month where actually 6 weeks covered. I suppose the easist is just to have the weeks as they appear and accept some months will 6 weeks with 2 of those weeks consisting of 1 or 2 days. Or you could start the month on week 2 when the first week starts with a Sat or Sun. I am open to your suggestions as well..... Kindest regards David

 

[Armstrong_N14]

maybe this?

Book4
	A	B
1	SOM	EOM
2	9/1/2024	9/30/2024
3
4	SOW	Weeks
5	1	09/01/24 to 09/07/24
6	8	09/08/24 to 09/14/24
7	15	09/15/24 to 09/21/24
8	22	09/22/24 to 09/28/24
9	29	09/29/24 to 09/30/24
Sheet1

Cell Formulas
Range	Formula
B2	B2	=EOMONTH(A2,0)
A5:A46	A5	=TOCOL(TEXT(SEQUENCE(6,7,-MOD(WEEKDAY(A2,2),7)+1,7)," [>"&DAY(EOMONTH(A2,0))&"];;#"))
B5:B9	B5	=IFERROR(TEXT(VALUE(DATE(YEAR($A$2),MONTH($A$2),A5)),"mm/dd/yy")&" to "&TEXT(VALUE(IF(DATE(YEAR($A$2),MONTH($A$2),A5)+6<=EOMONTH($A$2,0),DATE(YEAR($A$2),MONTH($A$2),A5)+6,EOMONTH($A$2,0))),"mm/dd/yy"),"")
Dynamic array formulas.