Spreadsheet: 809073d1670871928-countifs-based-on-a-date-test-report-2_etaf-3-
Sheet: Raw Data

First name | Last name | [NAME] | Job Title | Organization | Activity Name | Status | Enrollment Date | Completion date | Coupon Code | Column1 | Enrolled Week Beginning | Completed Week Beginning | Week Number Enroll | Week Number Complete | No of Days to [NAME] | No of Weeks to complete | Column2 |  |  |  |  |  |  |  |  | 2022-12-06 00:00:00
Davey | Wavey |  |  |  | L | Satisfied and Completed | 2022-11-04 06:03:00 | 2022-11-04 07:35:00 |  |  |  |  |  |  |  |  |  |  |  |  | Satisfied and Completed | 2022-11-04 00:00:00
[NAME] | Smith |  |  |  | L | Satisfied and Completed | 2022-11-07 07:30:00 | 2022-11-07 09:38:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-30 00:00:00
[NAME] | Farmer |  |  |  | L | In Progress | 2022-11-09 12:48:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-28 00:00:00
[NAME] | Llyod |  |  |  | L | Satisfied and Completed | 2022-11-17 04:41:00 | 2022-11-29 03:47:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-05 00:00:00
[NAME] | Guiness |  |  |  | L | In Progress | 2022-11-21 06:53:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-29 00:00:00
JULIE | Timpson |  |  |  | L | In Progress | 2022-11-23 09:40:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-06 00:00:00
Ian | Being |  |  |  | L | Satisfied and Completed | 2022-12-06 11:21:00 | 2022-12-06 13:06:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-02 00:00:00
[NAME] | Ian |  |  |  | L | Satisfied and Completed | 2022-11-24 09:50:00 | 2022-11-24 10:18:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-21 00:00:00
Nicole | Simple |  |  |  | L | Enrolled | 2022-11-24 11:35:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-01 00:00:00
Heather | Layton |  |  |  | L | Enrolled | 2022-11-25 10:31:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-07 00:00:00
Sara | [NAME] |  |  |  | L | In Progress | 2022-11-28 07:47:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-06 00:00:00
[NAME] | Farmers |  |  |  | L | In Progress | 2022-12-01 12:43:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-07 00:00:00
[NAME] | Beer |  |  |  | L | Enrolled | 2022-12-05 11:53:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-29 00:00:00
[NAME] | Smith |  |  |  | PF | Satisfied and Completed | 2022-11-07 09:42:00 | 2022-11-28 04:18:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-24 00:00:00
Davey | Wavey |  |  |  | PF | Satisfied and Completed | 2022-11-21 10:15:00 | 2022-11-30 09:48:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-07 00:00:00
[NAME] | Llyod |  |  |  | PF | In Progress | 2022-11-29 06:17:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-28 00:00:00
[NAME] | Beer |  |  |  | PF | Enrolled | 2022-12-05 11:55:00 |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-11-29 00:00:00
Ian | Being |  |  |  | PF | Satisfied and Completed | 2022-12-06 13:11:00 | 2022-12-06 14:02:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-01 00:00:00
[NAME] | Smith |  |  |  | PS | Satisfied and Completed | 2022-11-07 09:42:00 | 2022-11-28 08:03:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-06 00:00:00
Davey | Wavey |  |  |  | PS | Satisfied and Completed | 2022-11-21 10:15:00 | 2022-11-28 12:05:00 |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Satisfied and Completed | 2022-12-07 00:00:00
[NAME] | Ian |  |  |  | PS | In Progress | 2022-11-24 10:43:00
[NAME] | Llyod |  |  |  | PS | Enrolled | 2022-11-29 06:17:00
[NAME] | Beer |  |  |  | PS | Enrolled | 2022-12-05 11:56:00
Ian | Being |  |  |  | PS | Satisfied and Completed | 2022-12-07 01:46:00 | 2022-12-07 03:23:00
[NAME] | Smith |  |  |  | PS m | Satisfied and Completed | 2022-11-07 09:43:00 | 2022-11-28 09:15:00
[NAME] | Llyod |  |  |  | PS m | Enrolled | 2022-11-29 06:18:00
Davey | Wavey |  |  |  | PS m | Satisfied and Completed | 2022-11-30 09:52:00 | 2022-12-05 09:23:00
[NAME] | Beer |  |  |  | PS m | Enrolled | 2022-12-05 11:56:00
Ian | Being |  |  |  | PS m | Satisfied and Completed | 2022-12-07 03:24:00 | 2022-12-07 05:41:00
[NAME] | Smith |  |  |  | PS y | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-11-29 09:03:00
Davey | Wavey |  |  |  | PS y | Satisfied and Completed | 2022-11-29 05:13:00 | 2022-11-29 10:38:00
[NAME] | Llyod |  |  |  | PS y | Enrolled | 2022-11-29 06:18:00
[NAME] | Beer |  |  |  | PS y | Enrolled | 2022-12-05 11:57:00
Ian | Being |  |  |  | PS y | Satisfied and Completed | 2022-12-07 03:25:00 | 2022-12-07 07:10:00
[NAME] | Smith |  |  |  | PS n | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-01 09:09:00
[NAME] | Llyod |  |  |  | PS n | Enrolled | 2022-11-29 06:18:00
Davey | Wavey |  |  |  | PS n | Satisfied and Completed | 2022-11-30 09:53:00 | 2022-12-06 06:42:00
Gillian | White |  |  |  | PS n | In Progress | 2022-12-01 11:21:00
[NAME] | Beer |  |  |  | PS n | Enrolled | 2022-12-05 11:57:00
Ian | Being |  |  |  | PS n | Satisfied and Completed | 2022-12-07 03:26:00 | 2022-12-07 08:13:00
[NAME] | Smith |  |  |  | PS ts | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-06 09:39:00
[NAME] | Llyod |  |  |  | PS ts | Enrolled | 2022-11-29 06:19:00
Davey | Wavey |  |  |  | PS ts | Satisfied and Completed | 2022-11-30 09:55:00 | 2022-12-06 11:28:00
[NAME] | Beer |  |  |  | PS ts | Enrolled | 2022-12-05 11:57:00
Ian | Being |  |  |  | PS ts | Satisfied and Completed | 2022-12-07 08:15:00 | 2022-12-07 10:05:00
Davey | Wavey |  |  |  | QI 1t | Satisfied and Completed | 2022-11-01 11:23:00 | 2022-11-02 11:48:00
[NAME] | Smith |  |  |  | QI 1t | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-07 06:14:00
Mini | Molody |  |  |  | QI 1t | Enrolled | 2022-11-25 06:27:00
[NAME] | Llyod |  |  |  | QI 1t | Enrolled | 2022-11-29 06:19:00
[NAME] | Beer |  |  |  | QI 1t | Enrolled | 2022-12-05 11:58:00
Ian | Being |  |  |  | QI 1t | In Progress | 2022-12-07 10:08:00
[NAME] | Smith |  |  |  | QI t | Satisfied and Completed | 2022-11-07 09:44:00 | 2022-12-07 11:08:00
Davey | Wavey |  |  |  | QI t | Satisfied and Completed | 2022-11-16 04:10:00 | 2022-11-21 08:37:00
[NAME] | Llyod |  |  |  | QI t | Enrolled | 2022-11-29 06:19:00
[NAME] | Beer |  |  |  | QI t | Enrolled | 2022-12-05 11:58:00
[NAME] | Smith |  |  |  | [NAME] | Enrolled | 2022-11-07 09:45:00
Mini | Molody |  |  |  | [NAME] | Enrolled | 2022-11-25 06:28:00
[NAME] | Llyod |  |  |  | [NAME] | Enrolled | 2022-11-29 06:20:00
Davey | Wavey |  |  |  | [NAME] | Satisfied and Completed | 2022-11-30 09:50:00 | 2022-11-30 11:08:00
[NAME] | Beer |  |  |  | [NAME] | Enrolled | 2022-12-05 11:59:00
[NAME] | Smith |  |  |  | Qols | Enrolled | 2022-11-07 09:45:00
Mini | Molody |  |  |  | Qols | Enrolled | 2022-11-25 06:28:00
[NAME] | Llyod |  |  |  | Qols | Enrolled | 2022-11-29 06:20:00
Davey | Wavey |  |  |  | Qols | Satisfied and Completed | 2022-11-30 09:50:00 | 2022-12-01 09:25:00
[NAME] | Beer |  |  |  | Qols | Enrolled | 2022-12-05 11:59:00
[NAME] | Smith |  |  |  | Qent | Enrolled | 2022-11-07 09:45:00
Sara | [NAME] |  |  |  | Qent | Enrolled | 2022-11-28 07:44:00
[NAME] | Llyod |  |  |  | Qent | Enrolled | 2022-11-29 06:20:00
Davey | Wavey |  |  |  | Qent | Satisfied and Completed | 2022-11-30 09:54:00 | 2022-12-01 12:05:00
[NAME] | Beer |  |  |  | Qent | Enrolled | 2022-12-05 11:53:00
Mini | Molody |  |  |  | Qge | Enrolled | 2022-11-25 06:27:00
Davey | Wavey |  |  |  | Ts | Satisfied and Completed | 2022-11-03 11:24:00 | 2022-12-07 11:11:00
[NAME] | Smith |  |  |  | Ts | Enrolled | 2022-11-07 09:45:00
[NAME] | Llyod |  |  |  | Ts | Enrolled | 2022-11-29 06:20:00
[NAME] | Beer |  |  |  | Ts | Enrolled | 2022-12-05 12:00:00
Davey | Wavey |  |  |  | Im | Satisfied and Completed | 2022-12-07 11:11:00 | 2022-12-07 11:11:00