u/Environmental-Let987

Sorry for formatting, am on mobile. am trying to understand why a review metric is so low and think it could be due to production loading. On sheet 2 have the days in may On sheet 1 in a tablel have the following columns Work order #, production start date, production end date, quality review start, Quality review end date. Ineed to figure out how many orders were in production and in quality on the same days have included a photo but not sure what else can do sorry everyone

So for example I would need to count how many times 01 may would be in date range of column b: column c Any help would be much appreciated.

Work order	ST35 When	Cubicle End date	Status 75 When	Status 95 when
2202578	24/04/26	05/05/26	30/04/26	30/04/26
2202945	06/05/26	14/05/26	15/05/26	15/05/26
2203887	30/04/26	06/05/26	07/05/26	08/05/26
2213601	05/05/26	12/05/26	12/05/26	12/05/26
2220665	07/05/26	14/05/26	14/05/26	14/05/26
2221429	08/05/26	15/05/26	15/05/26	28/05/26
2221432	05/05/26	11/05/26	08/05/26	10/05/26
2221879	05/05/26	11/05/26	11/05/26	28/05/26
2221881	07/05/26	13/05/26	12/05/26	13/05/26