Countif using datedif

[chongki]

Hello, I have the following data on a sheet:

Book2
	A	B
1	Items	Expiry
2	Item 1	11/24/2023
3	Item 2	01/02/2024
4	Item 3	02/01/2024
5	Item 4	11/01/2023
6	Item 5	10/29/2023
7	Item 6	12/25/2023
8	Item 7	07/25/2023
9
10	# expiring in <1 month:
Sheet1

I need to count the items that are expiring in 1 month or less. The answer should be 3 and I try countif with datedif, but it's not working. Being a super beginner, the formula i used was =COUNTIF(B2:B8,DATEDIF(TODAY(),B2:B8,"M")<1), but it spills and outputs 0 all the way down. If I put the operator @ like so: =COUNTIF(B2:B8,DATEDIF(TODAY(),@B2:B8,"M")<1), it doesn't spill but just outputs 0.
Any help will be very very appreciated.

Thank you!

 

[etaf]

try
=COUNTIFS(B2:B8,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))
I make 4 as i have included an =
and 24/11/23 is the same date as today - if you do want to include that , then remove the = "<="& becomes "<"&

Book2
	A	B	C	D	E	F
1	Items	Expiry
2	Item 1	11/24/23	4		11/24/23	TRUE
3	Item 2	1/2/24			11/24/23	FALSE
4	Item 3	2/1/24			11/24/23	FALSE
5	Item 4	11/1/23			11/24/23	TRUE
6	Item 5	10/29/23			11/24/23	TRUE
7	Item 6	12/25/23			11/24/23	FALSE
8	Item 7	7/25/23			11/24/23	TRUE
Sheet1

Cell Formulas
Range	Formula
C2	C2	=COUNTIFS(B2:B8,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))
E2:E8	E2	=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
F2:F8	F2	=B2<=E2

 

[chongki]

try
=COUNTIFS(B2:B8,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))
I make 4 as i have included an =
and 24/11/23 is the same date as today - if you do want to include that , then remove the = "<="& becomes "<"&

Book2
	A	B	C	D	E	F
1	Items	Expiry
2	Item 1	11/24/23	4		11/24/23	TRUE
3	Item 2	1/2/24			11/24/23	FALSE
4	Item 3	2/1/24			11/24/23	FALSE
5	Item 4	11/1/23			11/24/23	TRUE
6	Item 5	10/29/23			11/24/23	TRUE
7	Item 6	12/25/23			11/24/23	FALSE
8	Item 7	7/25/23			11/24/23	TRUE
Sheet1

Cell Formulas
Range	Formula
C2	C2	=COUNTIFS(B2:B8,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))
E2:E8	E2	=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
F2:F8	F2	=B2<=E2

Thank you so so much! Works perfect!

 

[etaf]

you are welcome