CountIf the year of 2022 is between two dates

[Anonymous321]

I'm wanting to create a formula that will count cells if between two dates is the year 2022

Start	End	Should Count This
01/09/2021	08/09/2023	Should Count This
01/04/2022	01/09/2023	Should Count This
01/10/2021	04/02/2023	Should Count This
01/01/2021	12/12/2021	Shouldn't Count This

Any help will be appreciated. Thanks

 

[Phuoc]

Try this

Book1
	A	B	C
1	Start	End	Should Count This
2	1/9/2021	8/9/2023	Yes
3	1/4/2022	1/9/2023	Yes
4	1/10/2021	4/2/2023	Yes
5	1/1/2021	12/12/2021	No
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(AND(A2<=DATE(2022,12,31),B2>=DATE(2022,1,1)),"Yes","No")

 

[Skovgaard]

I'm wanting to create a formula that will count cells if between two dates is the year 2022

Start	End	Should Count This
01/09/2021	08/09/2023	Should Count This
01/04/2022	01/09/2023	Should Count This
01/10/2021	04/02/2023	Should Count This
01/01/2021	12/12/2021	Shouldn't Count This

Any help will be appreciated. Thanks

What about:

=COUNTIFS(A2:A5,"<"&DATE(2023,1,1),B2:B5,">"&DATE(2022,12,31))

/Skovgaard

 

[Fluff]

Should row 4 here be counted or not?

Fluff.xlsm
	A	B	C
1	Start	End	Should Count This
2	01/09/2021	08/09/2023
3	01/04/2022	01/09/2023
4	01/10/2021	04/02/2022	??
5	01/01/2021	12/12/2021
Data

 

[Anonymous321]

Should row 4 here be counted or not?

Fluff.xlsm
	A	B	C
1	Start	End	Should Count This
2	01/09/2021	08/09/2023
3	01/04/2022	01/09/2023
4	01/10/2021	04/02/2022	??
5	01/01/2021	12/12/2021
Data

Apologies should have explained it better
But yes it should be counted
I guess imagine its an employees start date and end date, if the employee at any point works in 2022 then it should count them. So in the that example, the employee did work in 2022 and so the formula should count them

 

[Fluff]

Ok, how about

=COUNTIFS(A:A,"<"&DATE(2023,1,1),B:B,">="&DATE(2022,1,1))

 

[Anonymous321]

Ok, how about

=COUNTIFS(A:A,"<"&DATE(2023,1,1),B:B,">="&DATE(2022,1,1))

Yes! This worked thanks

 

[Fluff]

Glad we could help & thanks for the feedback.