In column A, I have the date that the order was received. In column B, I have the date or time the order went into review. In column C, I have the date the order was completed. In column D, I have the date the order is due.
The due date (col. D) is either 1, 5, 7, or 10 days after the order was received (col. A).
If D is 5 or more days after A, then column B is populated by a date.
If D is 1 day after A and goes into review (B) the same day it is due (D), then column B is populated by a time.
If D is 1 day after A and goes into review after the day it is due, then column B is populated by a date.
I am trying to count how many 5 or more day turnarounds are completed per month. Using the following formula counts each cell in column B that contains a date (and not a time) during the specified completion date (C) range. But this counts all of the 1 day turnarounds that went out late.
=COUNTIFS(C:C,">="&date(2019,1,1),C:C,"<"&date(2019,2,1),B:B,">="&date(2019,1,1),B:B,"<"&date(2019,2,1))
Any ideas?
Sample Table.JPG
Bookmarks