Formula: if date falls between two dates BUT based on multiple returns

[VBANewbie123]

Hi, all.

I have a formula headache and wish to reach out.

I have a list of resources and dates against them. This basically shows tasks against the resource with start and finish dates. See below for example. I have a main resource calendar tab with dates across the months where the return cell needs a formula that returns how many tasks are against the resource.
The idea is if the resource has 1 task on that date return 1. Or return how many tasks against them on that date.

I have successfully returned the count based on the start and finish dates but the dates between need to also show.
Formula thus far:

=COUNTIFS(Proj1_Date1,Calendar!AL$3,Proj1_Name,$D10)+COUNTIFS(Proj1_Date2,Calendar!AL$3,Proj1_Name,$D10)

The below is "Task main view" and below that is "Resource calendar"

Name	From	To
Steve	04/01/2022​	13/01/2022​
Fliss	19/10/2022​	26/10/2022​
Wayne	02/02/2022​	12/02/2022​
Rui	31/12/2022​	15/01/2022​
Chris B	03/02/2022​	08/02/2022​
Dan	04/04/2022​	14/04/2022​
Dave B	03/11/2022​	05/11/2022​
Rui	02/12/2022​	03/12/2022​
Fliss	16/04/2022​	01/05/2022​
Chris B	05/05/2022​	19/05/2022​
Fliss	28/08/2022​	02/09/2022​
Steve	25/01/2022​	02/02/2022​
Kev	31/03/2022​	13/04/2022​
Kev	03/12/2022​	13/12/2022​
Chris B	12/12/2022​	25/12/2022​
Kev	25/02/2022​	04/03/2022​
Kev	09/05/2022​	21/05/2022​
Wayne	02/02/2022​	12/02/2022​
Rui	04/02/2022​	19/02/2022​

Jan​

Jan​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

Feb​

30​

31​

01​

02​

03​

04​

05​

06​

07​

08​

09​

10​

11​

12​

13​

14​

15​

16​

Steve

0​

0​

0​

1​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Cam

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Fliss

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Fliss

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Chris B

0​

0​

0​

0​

1​

0​

0​

0​

0​

1​

0​

0​

0​

0​

0​

0​

0​

0​

Kev

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Dave B

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Dan

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Dave B

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

Wayne

0​

0​

0​

2​

0​

0​

0​

0​

0​

0​

0​

0​

0​

2​

0​

0​

0​

0​

Lukasz

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

 

[Fluff]

How about

=COUNTIFS(Proj1_Date1,"<="&Calendar!AL$3,Proj1_Date2,">="&Calendar!AL$3,Proj1_Name,$D10)

 

[VBANewbie123]

How about

=COUNTIFS(Proj1_Date1,"<="&Calendar!AL$3,Proj1_Date2,">="&Calendar!AL$3,Proj1_Name,$D10)

Hi, Fluff.

Excellent and I couldn't see that! Thank you very much.

S

 

[Fluff]

Glad to help & thanks for the feedback.