My COUNTIFS formula has a SPILL

[JCKCorinna]

Hello
I have a spreadsheet that contains applicants, by business unit, and date entered into the system.
I need a quick way to summarize which business units received applications during a week ending period.
The formula I have written for column Q. =COUNTIFS(F:F,P5,I:I,I:I>O$2,I:I,I:I<=Q2) results in a SPILL

I need a count f applications that match COUMN P and are greater than last weeks ending date, and less than this weeks week ending date.
Any help is appreciated.

F

G

H

I

J

K

L

M

N

O

P

Q

R​

S​

2

Location

Division

Applicant Status

Entry Date

Activity Date

Hire Date

12/25/2022

WEEK ENDING:

1/6/2023​

1/13/2023​

1/20/2023​

3

CARL'S 8343 WILSONVILLE

HR - Hired

1/13/2023

1/19/2023 18:28

1/20/2023

4

CARL'S 8343 WILSONVILLE

HR - Hired

1/27/2023

2/3/2023 14:03

2/3/2023

Employer

STORE

Location Name

5

CARL'S 8343 WILSONVILLE

HR - Hired

2/13/2023

2/20/2023 19:39

2/20/2023

JCK

780

CARL'S 780 ROSEBURG STWRD PKWY

6

CARL'S 8343 WILSONVILLE

1 - Rejected

1/13/2023

1/24/2023 13:50

JCK

844

CARL'S 844 EUGENE W 11TH

7

CARL'S 8343 WILSONVILLE

1 - Rejected

1/21/2023

1/23/2023 11:31

JCK

867

CARL'S 867 SPRINGFIELD MARCOLA

8

CARL'S 8343 WILSONVILLE

1 - Offer Declined

1/4/2023

1/10/2023 11:25

JCK

896

CARL'S 896 CTTGE GROVE GATEWAY

9

CARL'S 8343 WILSONVILLE

1 - Rejected

2/1/2023

2/1/2023 13:18

JCK

7069

CARL'S 7069 SALEM LANCASTER NE

10

CARL'S 8343 WILSONVILLE

1 - Rejected

2/21/2023

2/21/2023 18:49

JCK

7070

CARL'S 7070 ALBANY WAVERLY DR

 

[DanteAmor]

How about:

=COUNTIFS(F:F,P5,I:I,">"&O$2,I:I,"<="&Q2)

 

[JCKCorinna]

BEST WEBSITE EVER!
Thank you for the speedy answer - saved the day!