Countifs formula

[DarrenF]

=countifs('YTD DATA'!$F:$F,"*Home Internet*",'YTD DATA'!$X:$X,"Open",'YTD DATA'!$I:$I,>7.5()NOW)

I'm trying to figure out the below ending part

YTD DATA'!$I:$I,>7.5()NOW

I need to say any date that has an open ticket greater than 7.5 days from now count it.

 

[Eric W]

Try:

=countifs('YTD DATA'!$F:$F,"*Home Internet*",'YTD DATA'!$X:$X,"Open",'YTD DATA'!$I:$I,">"&7.5+NOW())