I am writing a grant report in which I need to count the number of individuals who received a service during a specific quarter. That is, if the person was in our shelter any day between
The way the data is displayed, their entry date and their exit date is recorded. What I'm struggling with is, if I write a
countifs formula looking at whether or not their entry date OR their exit date occurs between
12/31/2015, I may miss individuals who entered on
9/30/2015 or earlier and exited on
1/1/2016 or later.
Those individuals may have been in shelter every day from
12/31/2015, but they would not be counted because their entry and exit dates occur outside of the date range
It may be that I need to do this in multiple steps (multiple columns doing different calculations that I can use to get the end result), but I'm not sure where to begin.