offset help

[chaossully]

This cell is showing R as a value i understand it has to do with the date being changed so its taking its populating in this any help to stop this from showing up would be greatly appreciated.

Error in date change.xlsx
	M																																																			BL	BM	BN	BO	BP	BQ	BR	BS	BT
9	AccRej																																																			Duplicate	Duplicate2	Duplicate3	Mold1	Mold2	Mold3	Mold4	Mold5	Signoffs
10	A																																																			2645A	1	No	A	452191	1		A	1
11	A																																																			2631A	1	No	A	452192	1		A	1
12	R																																																					No	R	452232	1	1	A	1
13	R																																																					No	R	452232
sheet1

Cell Formulas
Range	Formula
BL10:BL13	BL10	=IF([@AccRej]="A",CONCAT(Table1[@[SN]:[AccRej]]),"")
BM10:BM13	BM10	=IF([@AccRej]="A",COUNTIF([Duplicate],[@Duplicate]),"")
BN10:BN13	BN10	=IF(AND([@AccRej]="A",[@Duplicate2]>1),"Yes","No")
BO10:BO13	BO10	=[@AccRej]
BP10:BP13	BP10	=CONCAT([@InspDate],[@Shift])
BQ10:BQ13	BQ10	=IFERROR(IFS([@Mold2]<>OFFSET([@Mold2],-1,0),1,AND(OFFSET([@Mold3],-1,0)=1,OFFSET([Mold1],-1,0)="R"),1),"")
BR10:BR13	BR10	=IF(AND([@Mold3]=1,OFFSET([@Mold3],1,0)=""),1,"")
BS10:BS13	BS10	=IF(OR([@Mold4]=1,[@MoldCast]="A"),"A","")
BT10:BT13	BT10	=IF([@Mold2]<>OFFSET([@Mold2],-1,0),1,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M10:M207	Cell Value	contains "R"	text	NO

results in this

Error in date change.xlsx
	J	K
5	AccRej	MoldCast
6	A	A
7	A	A
8	A	A
9	A	A
10	A	A
11	R	0
12	A	A
13	A	A
14	A	A
15	A	A
16	A
17	A	A
18	A
19	A	A
20	A	A
21	A	A
22	A	A
23	A	A
24	A	A
25	A	A
Daily Verifications

Cell Formulas
Range	Formula
J6:J25	J6	=FILTER(Table1[AccRej],Table1[Mold5]="A")
K6:K25	K6	=FILTER(Table1[MoldCast],Table1[Mold5]="A")
Dynamic array formulas.