COUNTIFS (Name and date)

[Krisevans]

Hi Wonderful people,
Trying to get a countifs formulae to work based on the below:

COUNTIF first column = Text (got this solved)
COUNTIFS second column = yesterday (today - 1)

I tried the below, but to no avail

Countifs(A:A,"first interview booked,B:B,TODAY()-1

Also tried it with the above but the today - 1 being a cell value = d2 as example

Status

Date

First Interview booked	13/12/2023
First interview booked	12/12/2023
Second interview booked	13/12/2023

 

[etaf]

=COUNTIFS(A:A,"first interview booked",B:B,TODAY()-1)

Book2
	A	B	C	D
1	Status	Date
2	First Interview booked	12/13/23		1
3	First interview booked	12/12/23
4	Second interview booked	12/13/23
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTIFS(A:A,"first interview booked",B:B,TODAY()-1)

 

[Krisevans]

THANK YOU

 

[etaf]

you are welcome