COUNTIFS Date Cell Reference +-Days

FanofExcel18

Board Regular
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

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Fluff

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

FanofExcel18

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

Fluff

MrExcel MVP, Moderator
Glad you sorted it & thanks for the feedback