MATCH is off by 13

[Jar888]

For some reason my MATCH from sheet to sheet is off by 13 and I just can't work out why. See below example and also a snip of the two sheets showing the data it's pulling from 13 days prior to the MATCH date. Any help would be greatly appreciated ?

Cheat Sheet.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2	25/04/2022	26/04/2022	27/04/2022	28/04/2022	29/04/2022	30/04/2022	1/05/2022	2/05/2022	3/05/2022	4/05/2022	5/05/2022	6/05/2022	7/05/2022	8/05/2022	9/05/2022	10/05/2022	11/05/2022	12/05/2022	13/05/2022	14/05/2022
3
4	12D	12D	D	D	FO PM						FO AM	OST	OST	FI AM	D	D	D	D	FO PM
5				FI PM	D	D	D	D	D	D	FI ADL	FO AM								FI PM
6
7	12D	12D	D	D	D	D	FO AM				FI PM	D	D	D	D	D	D	D	FO PM
8			TRAINING	TRAINING	TRAINING	TRAINING	FI AM	D	D	D	D	FO PM				TRAINING	TRAINING	TRAINING	TRAINING	FI ADL
Roster Dump

Cell Formulas
Range	Formula
C2	C2	=Sheet1!F1-13
D2:V2	D2	=C2+1
C3	C3	=IFERROR(INDEX('[EMPLOYEE ROSTER.xlsx]ROSTER'!$N$5:$AWG$250,MATCH($A3,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$E$5:$E$250,0),MATCH(C$2,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$3:$3,0)),"0")
C4:V8,D3:V3	D3	=IFERROR(INDEX('[EMPLOYEE ROSTER.xlsx]ROSTER'!$N$5:$AWG$250,MATCH($A3,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$E$5:$E$250,0),MATCH(D$2,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$3:$3,0)),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:AR300	Expression	=A1="AL"	text	NO
C2:AZ2	Expression	=C$1="Mon"	text	NO

 

[StephenCrump]

Just a very quick observation (it's hard to see for sure, because of links to other sheets, and pictures rather than XL2BB) ...

There's a 13 column mismatch between: ROSTER'!$3:$3 and ROSTER'!$N$5:$AWG$250.