Count of compared dates in two arrays

[rjb2k]

Hi, please could someone help?

I'm looking for a formula that will count each occurrence of when a date in column A is greater than the corresponding row in column B (also a date).

So in the below example, the count would be 3

23 May 2021	12 May 2021
03 Aug 2021	03 Aug 2021
03 Aug 2021	01 May 2021
14 Jun 2021	20 Dec 2020

There are roughly 600 rows of dates in the dataset and dates in both columns are updated / changed periodically.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1
2	23/05/2021	12/05/2021	3
3	03/08/2021	03/08/2021
4	03/08/2021	01/05/2021
5	14/06/2021	20/12/2020
Master

Cell Formulas
Range	Formula
C2	C2	=COUNT(FILTER(ROW(A2:A5),A2:A5>B2:B5))

 

[Peter_SSs]

We should be able to count the dates directly rather than the row numbers.

21 08 03.xlsm
	A	B	C
1
2	23/05/2021	12/05/2021	3
3	3/08/2021	3/08/2021
4	3/08/2021	1/05/2021
5	14/06/2021	20/12/2020
Count Dates

Cell Formulas
Range	Formula
C2	C2	=COUNT(FILTER(A2:A5,A2:A5>B2:B5))

 

[rjb2k]

That's perfect.,

Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.