Countifs formula if date is greater than 7 days for student IDs across multiple sheets

jme_4477

New Member
Joined
Mar 24, 2016
Messages
43
I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for any student ID, I need a total. So if any students have not been contacted in more than 7 days, it should just give me the total number of students with no contact. This total will appear on a different sheet all together.

Here's a link to the file:

https://drive.google.com/file/d/1JpRkYu-9vfYiqBBhNVhIAsn9VhPc5hB8/view?usp=sharing
 

Forum statistics

Threads
1,084,753
Messages
5,379,673
Members
401,620
Latest member
Ankur Teotia

Some videos you may like

This Week's Hot Topics

Top