Date Range

[Kris10Courias]

Having trouble trying to make this work.......... if the month matches, then the date for this month falls within a date range - return "Exception", if not then return "OK".

MONTH INTO WAREHOUSE	LATE AFTER THIS DATE	EXCEPTION AFTER THIS DATE
JUN FOR JUN	9/06/2024​	10/06/2024​	16/06/2024​
JUL FOR JUL	7/07/2024​	8/07/2024​	14/07/2024​
JUL FOR AUG	7/07/2024​	8/07/2024​	14/07/2024​
AUG FOR AUG	11/08/2024​	12/08/2024​	18/08/2024​

EXCEPTION DATE	ETA	Customer Reference Number
"EXCEPTION"	24/05/2024	AUG FOR AUG

 

[awoohaw]

you have 3 date columns, which date are you comparing the ETA with?
I am guessing you want to use one of dates on the row where AUG FOR AUG matches in the first column?
what do you mean by "within a range"

Here is using EXCEPTION AFTER THIS DATE:

Book1
	A	B	C	D
1	MONTH INTO WAREHOUSE	LATE AFTER THIS DATE	EXCEPTION AFTER THIS DATE
2	JUN FOR JUN	2024-06-09	2024-06-10	2024-06-16
3	JUL FOR JUL	2024-07-07	2024-07-08	2024-07-14
4	JUL FOR AUG	2024-07-07	2024-07-08	2024-07-14
5	AUG FOR AUG	2024-08-11	2024-08-12	2024-08-18
6
7	EXCEPTION DATE	ETA	Customer Reference Number
8	"EXCEPTION"	2024-05-24	AUG FOR AUG
9		2024-08-01	AUG FOR AUG	EXCEPTION
Sheet7

Cell Formulas
Range	Formula
D8:D9	D8	=IF(MONTH(XLOOKUP(C8,$A$2:$A$5,$C$2:$C$5))=MONTH(B8),"EXCEPTION","")