I have a sheet with multiple employees training dates setup as a numbered range (ie, fiscal year/fiscal week like 201604). Because the training is not always the same length of time, I need to be able to show how many employees are in training for each fiscal week. However, because the data is stored per employee, I have multiple training start/end dates, and every time I try using 'countifs' it comes back with zero, even though I know I have 79 people in training this week.
Is there a way to countif for each employee since the date ranges are there for each person?
Is there a way to countif for each employee since the date ranges are there for each person?