Multiple Dates (columns) are within range

[karldugan]

Hi all,

I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check if there was something easier . The selected range is N5 : R6 (exc headers).

Thanks,
Karl.

LBA Date	Issue Date	Judgement Date	Enforcement Date	Forfeiture Date
06/05/2022	30/05/2022	08/08/2022	05/07/2022	16/08/2022
27/11/2022	21/12/2022	01/03/2023	26/01/2023	09/03/2023

 

[earthworm]

One solution using conditional formatting.

Book1
	A	B	C	D	E
1	LBA Date	Issue Date	Judgement Date	Enforcement Date	Forfeiture Date
2	6-May-22	30-May-22	8-Aug-22	25-Dec-22	16-Aug-22
3	27-Nov-22	21-Dec-22	1-Mar-23	26-Jan-23	9-Mar-23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E3	Expression	=AND(A2>=44920,A2<=44928)	text	NO