COUNTIFS Date Cell Reference +-Days

[FanofExcel18]

Trying to figure out a Countifs formula to provide Something that is greater than 30 days but less than 90. Using a cell reference for the date.

Example: A1 = 1/6/2020, trying to figure out if its greater than 30 days
I've tried but can't figure it out:
=COUNTIFS(Sheet2!B:B,D2,Sheet2!C:C,">="&$A$1+30,Sheet2!C:C,"<"&$A$1+90)
=COUNTIFS(Sheet2!B:B,D2,Sheet2!C:C,">="&($A$1+30),Sheet2!C:C,"<"&($A$1+90))

Table:

1/6/2020​	Person	Date	Name	Count
	John Smith	1/4/2020 14:27	John Smith	0​
	John Smith	1/4/2020 11:27	Jane Doe	0​
	Jane Doe	1/4/2020 4:01
	Jane Doe	1/3/2020 20:02
	Jane Doe	11/20/2019 15:18
	Jane Doe	11/20/2019 13:10
	John Smith	11/20/2019 11:01
	Jane Doe	11/20/2019 10:02
	Jane Doe	11/20/2019 8:58
	John Smith	11/20/2019 8:40
	Jane Doe	11/20/2019 8:20
	Jane Doe	11/19/2019 23:01
	John Smith	11/19/2019 16:19

 

[Fluff]

That formula works for me, are you sure that your dates are real dates & not text?

 

[FanofExcel18]

I figured it out....I had reverse my Less than Equal to and change "+" to - ...appreciate the review

 

[Fluff]

Glad you sorted it & thanks for the feedback