Thank you for your help. That didn't work though

It actually counted everyone.

What I'm looking for is a formula that only calculates the more than 7 days

*until* there is a date entered.

So if we are on the Enrollment tab, look at column G, this column should only count a total if no date appears in So the formula is looking at Sheet 2, Column G:

=IFERROR(IF(OR(INDEX(Sheet2!$J$2:$J$18,MATCH(B2,Sheet2!$C$2:$C$18,0))="",INDEX(Sheet2!$J$2:$J$18,MATCH(B2,Sheet2!$C$2:$C$18,0))-7 > A2),1,0),0)

It’s comparing the date in Enrollment tab, Column A to Sheet 2, Column J. It’s looking to see if there’s a date past 7 days in there. What I need, though, is it only to look if there’s a date past 7 days if 1) in Sheet 2 there’s an ID number in Column C, 2) there’s nothing entered in Sheet 2, Column J, and 3) if it’s been longer than 7 days based on the date in Enrollment tab, Column A.

I can probably modify the other formulas in the Enrollment tabs J and M once I know how to do this, but for everything, I need it not to calculate any longer once a date is entered.

Does this help?

Thank you again!!!