Counting (COUNTIFS) based on two date criteria within 30 days of one another

[HalpNeeded]

Hello, first time poster here, though I've used the forums for many questions trying to resolve my excel stupidity.

I am hoping the collective wisdom can help me craft a formula to determine a COUNT of records.

I have a large data dump with thousands of records and I am trying count how many records are being "closed" within 30 days of them being opened.

These are in a large Table, with many other columns of data that I also filter by to narrow down the COUNT, but it is the date range criteria that is throwing me for a loop.
I have seen similar questions asked, but using TODAY()-30 as a way to determine the count, however, this is not something ran on the current day, but against historical data that is over 30 days old.

I apologize I cannot seem to get the mini-sheet addon working (whether computer or personal), so I will post an image instead.
My feeble attempt is shown in the screenshot and what my expected outcomes of the count (16) would be.

I am not sure how to place a table column as part of the criteria of the COUNTIFS statement without getting an error.

I appreciate any help figuring this out. Cheers.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(--((B2:B19-A2:A19)<=30))

 

[HalpNeeded]

Hello Fluff, thanks for responding so quickly!

The formula works, but giving me a result of 0.

I would have a 2nd question about that, can a SUM be nested within a COUNTIFS? I have multiple other criteria as well being used to narrow down by excluding some records.

 

[Fluff]

If you are getting a result of 0, then check that your dates are real dates & not text. Select the column & change the format to General, do you dates or numbers?

 

[HalpNeeded]

Hello Fluff,

This is the result I get when converting to General.

Date/Time Requested	Date/Time Closed
44615.51209​	44615.53819 ​

 

[Fluff]

In that case they are real dates, so the formula I suggested should work.

+Fluff 1.xlsm
	A	B	C	D
1
2	10/02/2022	22/02/2022		16
3	02/02/2022	11/02/2022
4	03/02/2022	12/02/2022
5	04/02/2022	13/02/2022
6	05/02/2022	14/04/2022
7	06/02/2022	15/02/2022
8	07/02/2022	16/02/2022
9	08/02/2022	17/02/2022
10	09/02/2022	18/02/2022
11	10/02/2022	19/02/2022
12	11/02/2022	20/02/2022
13	12/02/2022	21/04/2022
14	13/02/2022	22/02/2022
15	14/02/2022	23/02/2022
16	15/02/2022	24/02/2022
17	16/02/2022	25/02/2022
18	17/02/2022	26/02/2022
19	18/02/2022	27/02/2022
Lists

Cell Formulas
Range	Formula
D2	D2	=SUM(--((B2:B19-A2:A19)<=30))

 

[HalpNeeded]

Fluff, thank you. It does work, I figured out what I did wrong with my original. I swapped the columns (A-B, instead of B-A).

I will see if I can work this into my COUNT or change the primary formula to the a SUM instead.

Thanks a lot!

 

[Fluff]

Glad to help & thanks for the feedback.