Spreadsheet: 153399d1335892375-counting-cells-that-fall-in-a-date-range-and-meet-a-yes-no-condition-test
Sheet: Test

Date | All ICAs completed? | GCR-related? |  |  |  |  | updated
2012-01-03 07:27:39 | NO | NO |  |  | # of GCR Related
2012-01-04 00:00:00 | NO | NO |  | January | ?
2012-01-06 14:11:29 | YES | NO |  | February | ?
2012-01-09 00:00:00 | NO | NO |  | March | ?
2012-01-09 00:00:00 | NO | YES |  | April | ?
2012-01-10 00:00:00 | NO | NO
2012-01-10 00:00:00 | NO | NO
2012-01-10 08:35:51 | NO | NO
2012-01-12 00:00:00 | NO | NO
2012-01-15 00:00:00 | NO | NO
2012-01-19 08:42:29 | NO | YES
2012-01-20 11:17:59 | YES | NO
2012-01-23 09:07:39 | NO | YES
2012-01-24 00:00:00 | NO | NO
2012-01-24 07:23:04 | NO | NO
2012-01-25 11:14:09 | NO | NO
2012-01-27 08:36:16 | NO | NO
2012-01-31 08:53:07 | NO | NO
2012-01-31 10:47:25 | NO | NO
2012-02-01 10:50:19 | NO | NO
2012-02-02 09:25:56 | NO | NO
2012-02-04 00:00:00 | YES | NO
2012-02-07 00:00:00 | NO | YES
2012-02-07 06:57:14 | YES | NO
2012-02-09 08:41:07 | YES | NO
2012-02-09 18:07:35 | NO | NO
2012-02-09 18:17:54 | NO | NO
2012-02-10 06:48:03 | NO | NO
2012-02-10 11:43:54 | NO | NO
2012-02-14 04:50:29 | NO | NO
2012-02-14 18:13:18 | NO | NO
2012-02-16 13:16:28 | NO | NO
2012-02-20 00:00:00 | NO | NO
2012-02-20 12:39:32 | NO | NO
2012-02-21 07:11:59 | YES | NO
2012-02-21 09:38:20 | YES | NO
2012-02-22 00:52:25 | YES | NO
2012-02-22 07:32:46 | NO | YES
2012-02-22 07:50:54 | YES | YES
2012-02-23 00:00:00 | NO | NO
2012-02-23 00:00:00 | NO | NO
2012-02-23 00:00:00 | NO | NO
2012-02-24 00:00:00 | NO | NO
2012-02-26 00:00:00 | NO | NO |  |  |  |  | x
2012-02-28 14:24:16 | NO | NO
2012-02-29 00:04:13 | NO | NO
2012-02-29 09:32:26 | NO | NO
2012-02-29 10:15:51 | NO | NO
2012-02-29 10:15:51 | NO | NO
2012-03-01 00:00:00 | YES | NO
2012-03-02 00:00:00 | NO | NO
2012-03-05 00:00:00 | YES | NO
2012-03-06 00:00:00 | NO | NO |  |  |  |  | x
2012-03-07 00:00:00 | NO | NO
2012-03-07 00:00:00 | NO | NO
2012-03-10 00:00:00 | NO | YES |  |  |  |  | x
2012-03-11 00:00:00 | NO | YES |  |  |  |  | x
2012-03-12 00:00:00 | NO | NO
2012-03-13 00:00:00 | NO | NO
2012-03-13 00:00:00 | NO | NO
2012-03-13 00:00:00 | NO | NO
2012-03-13 00:00:00 | NO | NO
2012-03-14 00:00:00 | NO | NO
2012-03-14 00:00:00 | NO | NO
2012-03-16 00:00:00 | NO | NO
2012-03-19 00:00:00 | NO | NO
2012-03-20 00:00:00 | NO | YES
2012-03-20 00:00:00 | NO | NO
2012-03-20 00:00:00 | NO | NO
2012-03-20 00:00:00 | NO | NO |  |  |  |  | x
2012-03-21 00:00:00 | NO | NO
2012-03-21 00:00:00 | NO | NO
2012-03-22 00:00:00 | YES | NO
2012-03-23 00:00:00 | NO | NO
2012-03-25 00:00:00 | YES | NO
2012-03-26 00:00:00 | NO | NO
2012-03-28 00:00:00 | NO | YES
2012-03-28 00:00:00 | NO | NO
2012-03-29 00:00:00 | NO | NO
2012-03-29 00:00:00 | NO | NO |  |  |  |  | x
2012-03-29 00:00:00 | NO | NO |  |  |  |  | x
2012-04-02 00:00:00 | NO | NO
2012-04-02 00:00:00 | NO | YES
2012-04-03 00:00:00 | NO | NO
2012-04-06 00:00:00 | NO | NO |  |  |  |  | x
2012-04-09 00:00:00 | NO | NO
2012-04-12 00:00:00 | YES | NO
2012-04-12 00:00:00 | NO | NO
2012-04-16 00:00:00 | NO | YES
2012-04-16 00:00:00 | NO | NO
2012-04-13 00:00:00 | NO | NO
2012-04-17 00:00:00 | NO | NO
2012-04-17 00:00:00 | NO | NO
2012-04-17 00:00:00 | NO | NO
2012-04-24 00:00:00 | NO | NO
2012-04-24 00:00:00 | NO | NO
2012-04-24 00:00:00 | NO | NO
2012-04-25 00:00:00 | NO | YES
2012-04-25 00:00:00 | NO | NO
2012-04-25 00:00:00 | NO | NO