Sequence restarts when week number changes

[JEH0714]

Greetings, What I am trying to do is number forms based on week number and an increasing number based on how many forms have been created that week.
The form number will be as follows, Year, Week Number, Sequence number -
202226-01
202226-02
week number changes the sequence number starts over at 01
202227-01
I'm using helper cells to keep the week number, the "-" between the week number and the, Sequence number (AW5 is the Concatenation of the three. the Week number comes from he date entered in AL2

any help would be appreciated.

MASTER - PMM SHIPPER DOCUMENTATION-DOCUMENT NUMBER TEST.xlsx.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY
1
2													This row will not print or show on PDF													Document Date:												7/23/2022
3
4										Factory Certfied Shipper Documentation
5																																																	202229-02	-	02
6		Customer:					ESP Company					Wellname:									Installed Date							Sales Order
7																														Doc No.								202229-02
8		Well Type:											Salesman
9
10
11		Product Details
Master

Cell Formulas
Range	Formula
AW5	AW5	=CONCATENATE(TEXT(AL2,"yyyy") & TEXT(WEEKNUM(AL2,21),"00")-(AND(MONTH(AL2)=12,WEEKNUM(AL2,21)=1)),TEXT(CONCATENATE(AX5,AY5),"0,#"))
AL7	AL7	=AW5

Cells with Data Validation
Cell	Allow	Criteria
E9:G9	List	=INDIRECT("tbl_well_type")
D8:K8	List	=INDIRECT("tbl_well_type")