COUNTIFS Date Range Weekly

[mlightsey]

Good Evening All,

Background Info: Active Duty Military Paralegal. Excel knowledge moderate self taught youtube and forums.

Purpose: Create a spreadsheet to track new cases received, cases pending processing, and cases marked out on a weekly basis from Wednesday - Tuesday

Frequency: Once a week from Wednesday - Tuesday

Issue: Is there a better way to count/track cases received, cases pending processing, and cases mark out?

Under "Numbers" I created my formula page by breaking down the weeks into 52 weeks.

"Received" =COUNTIFS('ADSEP TRACKER'!$H$2:$H$202,">="&A2,'ADSEP TRACKER'!$H$2:$H$202,"<="&$B2) to count the case in for the week;

"OUT" =COUNTIFS('ADSEP TRACKER'!$L$2:$L$202,">="&A2,'ADSEP TRACKER'!$L$2:$L$202,"<="&B2)

"Pending" =E4+C5-D5

Thank you in advance for any assistance.