The attached workbook employs simple COUNTIFS formulas. For Interviews:Other Status categories would take similar form.![]()
=COUNTIFS($B$2:$B$16,"Interview",$D$2:$D$16,">="&$G$4,$D$2:$D$16,"<"&$G$4+7)
The attached workbook employs simple COUNTIFS formulas. For Interviews:Other Status categories would take similar form.![]()
=COUNTIFS($B$2:$B$16,"Interview",$D$2:$D$16,">="&$G$4,$D$2:$D$16,"<"&$G$4+7)
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks