Spreadsheet: 585066d1533603123-formula-for-identifying-start-date-and-finish-date-and-associated-number-of-days-sample-workflowv1
Sheet: Sheet1

CONTRACT NUMBER | Start date | Final completion date
262-18 | 28/03/2018 at 10:12 AM | 28/03/2018 at 11:09 AM
262-18 | 28/03/2018 at 11:09 AM | 29/03/2018 at 9:07 AM
262-18 | 29/03/2018 at 9:07 AM | 29/03/2018 at 9:07 AM
262-18 | 29/03/2018 at 9:07 AM | 3/04/2018 at 11:42 AM
262-18 | 3/04/2018 at 1:31 PM | 3/04/2018 at 1:31 PM
262-18 | 3/04/2018 at 1:31 PM | 4/04/2018 at 2:07 PM
262-18 | 3/04/2018 at 11:42 AM | 3/04/2018 at 12:31 PM
262-18 | 3/04/2018 at 12:31 PM | 3/04/2018 at 1:31 PM
262-18 | 4/04/2018 at 2:07 PM | 4/04/2018 at 2:09 PM
262-18 | 4/04/2018 at 2:09 PM | 4/04/2018 at 2:23 PM
262-18 | 4/04/2018 at 2:23 PM | 6/04/2018 at 12:35 PM
262-18 | 13/03/2018 at 8:18 AM | 14/03/2018 at 3:27 PM
262-18 | 15/03/2018 at 4:51 PM | 19/03/2018 at 4:18 PM
262-18 | 15/03/2018 at 8:38 AM | 15/03/2018 at 4:51 PM
262-18 | 19/03/2018 at 4:18 PM | 19/03/2018 at 5:46 PM
262-18 | 19/03/2018 at 5:46 PM | 20/03/2018 at 11:46 AM
262-18 | 20/03/2018 at 11:46 AM | 21/03/2018 at 9:18 AM
262-18 | 21/03/2018 at 9:18 AM | 21/03/2018 at 9:41 AM
262-18 | 21/03/2018 at 9:41 AM | 22/03/2018 at 10:38 AM
262-18 | 22/03/2018 at 10:38 AM | 26/03/2018 at 1:02 PM
262-18 | 26/03/2018 at 1:02 PM | 26/03/2018 at 2:41 PM
262-18 | 26/03/2018 at 2:41 PM | 28/03/2018 at 10:24 AM
098-17 | 25/05/2018 at 1:18 PM | 31/05/2018 at 10:18 AM
098-17 | 31/05/2018 at 10:18 AM | 31/05/2018 at 3:29 PM
098-17 | 31/05/2018 at 3:29 PM | 5/06/2018 at 12:15 PM
098-17 | 5/06/2018 at 12:15 PM | 5/06/2018 at 7:03 PM
098-17 | 5/06/2018 at 12:15 PM | 5/06/2018 at 12:15 PM
098-17 | 5/06/2018 at 7:03 PM | 6/06/2018 at 1:00 PM
098-17 | 6/06/2018 at 1:00 PM | 6/06/2018 at 3:11 PM
098-17 | 6/06/2018 at 3:11 PM | 7/06/2018 at 9:23 AM
098-17 | 7/06/2018 at 9:23 AM | 8/06/2018 at 2:46 PM
098-17 | 8/06/2018 at 2:46 PM | 8/06/2018 at 2:46 PM
098-17 | 8/06/2018 at 2:46 PM | 8/06/2018 at 3:12 PM
174-18 | 11/04/2018 at 10:08 AM | 11/04/2018 at 11:39 AM
174-18 | 11/04/2018 at 11:39 AM | 11/04/2018 at 12:12 PM
174-18 | 15/03/2018 at 5:10 PM | 19/03/2018 at 12:03 PM
174-18 | 19/03/2018 at 12:03 PM | 21/03/2018 at 4:21 PM
174-18 | 2/03/2018 at 10:41 AM | 15/03/2018 at 5:10 PM
174-18 | 21/03/2018 at 4:21 PM | 22/03/2018 at 1:56 PM
174-18 | 22/03/2018 at 1:56 PM | 9/04/2018 at 8:57 AM
174-18 | 9/04/2018 at 11:41 AM | 11/04/2018 at 10:08 AM
174-18 | 9/04/2018 at 8:57 AM | 9/04/2018 at 8:57 AM
174-18 | 9/04/2018 at 8:57 AM | 9/04/2018 at 11:41 AM
005-17 | 10/04/2018 at 9:55 AM | 11/04/2018 at 4:07 PM
005-17 | 11/04/2018 at 4:07 PM | 17/04/2018 at 9:08 AM
005-17 | 17/04/2018 at 9:08 AM | 17/04/2018 at 9:50 AM
005-17 | 17/04/2018 at 9:50 AM | 19/04/2018 at 10:15 AM
005-17 | 19/04/2018 at 10:15 AM | 19/04/2018 at 10:23 AM
005-17 | 19/04/2018 at 10:23 AM | 19/04/2018 at 10:54 AM
005-17 | 19/04/2018 at 10:54 AM | 19/04/2018 at 10:54 AM
005-17 | 19/04/2018 at 10:54 AM | 23/04/2018 at 12:30 PM
005-17 | 23/04/2018 at 12:30 PM | 24/04/2018 at 11:53 AM
005-17 | 24/04/2018 at 11:53 AM | 24/04/2018 at 12:21 PM
005-17 | 24/04/2018 at 12:21 PM | 26/04/2018 at 3:49 PM
007-17 | 1/05/2018 at 7:59 AM | 6/06/2018 at 12:17 PM
007-17 | 26/06/2018 at 12:58 PM | 28/06/2018 at 12:19 PM
007-17 | 26/06/2018 at 9:11 AM | 26/06/2018 at 12:58 PM
007-17 | 28/06/2018 at 12:19 PM | 29/06/2018 at 10:42 AM
007-17 | 29/06/2018 at 10:42 AM | 29/06/2018 at 11:08 AM
007-17 | 29/06/2018 at 11:08 AM | 29/06/2018 at 1:13 PM
007-17 | 6/06/2018 at 12:17 PM | 6/06/2018 at 12:18 PM
007-17 | 6/06/2018 at 12:18 PM | 6/06/2018 at 7:24 PM
007-17 | 6/06/2018 at 7:24 PM | 8/06/2018 at 6:25 PM
007-17 | 6/06/2018 at 7:24 PM | 6/06/2018 at 7:24 PM
007-17 | 8/06/2018 at 6:25 PM | 26/06/2018 at 9:11 AM
007-17V3 | 4/07/2018 at 12:59 PM | 4/07/2018 at 2:27 PM
007-17V3 | 4/07/2018 at 2:27 PM | 4/07/2018 at 2:27 PM
007-17V3 | 4/07/2018 at 2:27 PM | 4/07/2018 at 4:19 PM
007-17V3 | 4/07/2018 at 4:19 PM | 4/07/2018 at 4:19 PM
007-17V3 | 4/07/2018 at 4:19 PM | 5/07/2018 at 11:17 AM
007-17V3 | 4/07/2018 at 9:24 AM | 4/07/2018 at 12:59 PM
007-17V3 | 5/07/2018 at 11:17 AM | 5/07/2018 at 11:21 AM
007-17V3 | 5/07/2018 at 11:21 AM | 5/07/2018 at 11:21 AM
007-17V3 | 5/07/2018 at 11:21 AM | 5/07/2018 at 2:41 PM
007-17V3 | 5/07/2018 at 2:41 PM | 5/07/2018 at 3:07 PM
007-17V3 | 5/07/2018 at 3:07 PM | 5/07/2018 at 4:31 PM
012-17 | 1/06/2018 at 2:27 PM | 1/06/2018 at 2:27 PM
012-17 | 1/06/2018 at 2:27 PM | 5/06/2018 at 12:23 PM
012-17 | 10/04/2018 at 9:13 AM | 13/04/2018 at 12:31 PM
012-17 | 13/04/2018 at 12:31 PM | 19/04/2018 at 1:51 PM
012-17 | 19/04/2018 at 1:51 PM | 3/05/2018 at 9:35 AM
012-17 | 3/05/2018 at 9:35 AM | 31/05/2018 at 8:48 AM
012-17 | 3/05/2018 at 9:35 AM | 3/05/2018 at 9:35 AM
012-17 | 31/05/2018 at 8:48 AM | 1/06/2018 at 2:27 PM
012-17 | 5/06/2018 at 12:23 PM | 7/06/2018 at 9:13 AM
012-17 | [NAME] at 10:06 AM | 7/06/2018 at 12:24 PM
012-17 | 7/06/2018 at 9:13 AM | [NAME] at 10:06 AM
015-17 | 14/06/2018 at 10:27 AM | 17/06/2018 at 1:47 PM
015-17 | 17/06/2018 at 1:47 PM | 18/06/2018 at 2:49 PM
015-17 | 18/06/2018 at 2:49 PM | 20/06/2018 at 12:40 PM
015-17 | 20/06/2018 at 12:40 PM | 22/06/2018 at 8:54 AM
015-17 | 22/06/2018 at 3:45 PM | 25/06/2018 at 11:28 AM
015-17 | 22/06/2018 at 8:54 AM | 22/06/2018 at 3:45 PM
015-17 | 25/06/2018 at 1:10 PM | 26/06/2018 at 9:27 AM
015-17 | 25/06/2018 at 11:28 AM | 25/06/2018 at 1:10 PM
015-17 | 30/05/2018 at 4:48 PM | 31/05/2018 at 11:00 AM
015-17 | 31/05/2018 at 11:00 AM | 14/06/2018 at 10:27 AM
015-17 | 6/04/2018 at 3:05 PM | 30/05/2018 at 4:48 PM
018-17 | 12/03/2018 at 2:50 PM | 13/03/2018 at 7:37 AM
018-17 | 13/03/2018 at 7:37 AM | 15/03/2018 at 12:33 PM
018-17 | 15/03/2018 at 12:33 PM | 20/03/2018 at 11:43 AM
018-17 | 20/03/2018 at 11:43 AM | 20/03/2018 at 12:02 PM
018-17 | 20/03/2018 at 12:02 PM | 20/03/2018 at 12:02 PM
018-17 | 20/03/2018 at 12:03 PM | 20/03/2018 at 5:36 PM
018-17 | 20/03/2018 at 5:36 PM | 20/03/2018 at 5:39 PM
018-17 | 20/03/2018 at 5:39 PM | 21/03/2018 at 2:50 PM
018-17 | 21/03/2018 at 2:50 PM | 21/03/2018 at 3:04 PM
018-17 | 5/03/2018 at 11:27 AM | 12/03/2018 at 2:50 PM
020-17 | 1/06/2018 at 8:39 AM | 4/06/2018 at 5:05 PM
020-17 | 1/06/2018 at 8:39 AM | 1/06/2018 at 8:39 AM
020-17 | 22/05/2018 at 11:08 AM | 1/06/2018 at 8:39 AM
020-17 | 4/06/2018 at 5:05 PM | 4/06/2018 at 5:05 PM
020-17 | 4/06/2018 at 5:05 PM | 4/06/2018 at 5:05 PM
020-17 | 4/06/2018 at 5:05 PM | 4/06/2018 at 5:05 PM
020-17 | 4/06/2018 at 5:05 PM | 4/06/2018 at 5:05 PM
020-17 | 4/06/2018 at 5:06 PM | 5/06/2018 at 3:54 PM
020-17 | 5/06/2018 at 3:54 PM | 5/06/2018 at 4:43 PM
020-17 | 5/06/2018 at 4:43 PM | 5/06/2018 at 4:43 PM
020-17 | 5/06/2018 at 4:43 PM | 6/06/2018 at 1:55 PM
020-17V1 | 15/06/2018 at 3:41 PM | 18/06/2018 at 1:00 PM
020-17V1 | 18/06/2018 at 1:00 PM | 19/06/2018 at 12:40 PM
020-17V1 | 19/06/2018 at 1:52 PM | 19/06/2018 at 1:54 PM
020-17V1 | 19/06/2018 at 1:54 PM | 19/06/2018 at 2:13 PM
020-17V1 | 19/06/2018 at 12:41 PM | 19/06/2018 at 1:52 PM
020-17V1 | 19/06/2018 at 2:13 PM | 21/06/2018 at 12:23 PM
020-17V1 | 21/06/2018 at 12:23 PM | 22/06/2018 at 11:19 AM
020-17V1 | 22/06/2018 at 11:19 AM | 26/06/2018 at 8:32 AM
020-17V1 | 26/06/2018 at 8:32 AM | 26/06/2018 at 8:54 AM
020-17V1 | 26/06/2018 at 8:54 AM | 26/06/2018 at 8:55 AM
020-17V1 | 26/06/2018 at 8:55 AM | 26/06/2018 at 5:01 PM
027-17 | 1/03/2018 at 3:04 PM | 1/03/2018 at 3:50 PM
027-17 | 20/02/2018 at 12:41 PM | 22/02/2018 at 1:18 PM
027-17 | 22/02/2018 at 1:18 PM | 22/02/2018 at 4:09 PM
027-17 | 22/02/2018 at 4:09 PM | 23/02/2018 at 1:59 PM
027-17 | 23/02/2018 at 1:59 PM | 23/02/2018 at 2:57 PM
027-17 | 23/02/2018 at 2:57 PM | 23/02/2018 at 4:16 PM
027-17 | 23/02/2018 at 4:16 PM | 27/02/2018 at 1:57 PM
027-17 | 27/02/2018 at 1:57 PM | 1/03/2018 at 3:04 PM
029-17 | 1/05/2018 at 11:06 AM | 11/05/2018 at 1:58 PM
029-17 | 1/06/2018 at 2:53 PM | 1/06/2018 at 3:41 PM
029-17 | 1/06/2018 at 3:41 PM | 4/06/2018 at 1:22 PM
029-17 | 11/05/2018 at 1:58 PM | 16/05/2018 at 10:19 AM
029-17 | 16/05/2018 at 10:19 AM | 16/05/2018 at 11:14 AM
029-17 | 16/05/2018 at 11:14 AM | 16/05/2018 at 12:03 PM
029-17 | 16/05/2018 at 11:14 AM | 16/05/2018 at 11:14 AM
029-17 | 16/05/2018 at 12:03 PM | 31/05/2018 at 2:01 PM
029-17 | 31/05/2018 at 2:01 PM | 1/06/2018 at 2:53 PM
029-17 | 4/06/2018 at 1:22 PM | 4/06/2018 at 4:45 PM
029-17 | 4/06/2018 at 4:45 PM | 5/06/2018 at 9:33 AM
030-17 | 12/04/2018 at 4:44 PM | 12/04/2018 at 5:02 PM
030-17 | 12/04/2018 at 5:02 PM | 13/04/2018 at 11:17 AM
030-17 | 13/04/2018 at 11:17 AM | 13/04/2018 at 11:17 AM
030-17 | 13/04/2018 at 11:17 AM | 13/04/2018 at 4:06 PM
030-17 | 13/04/2018 at 4:06 PM | 18/04/2018 at 1:40 PM
030-17 | 15/03/2018 at 2:47 PM | 15/03/2018 at 2:47 PM
030-17 | 15/03/2018 at 2:47 PM | 28/03/2018 at 10:30 AM
030-17 | 18/04/2018 at 1:40 PM | 18/04/2018 at 2:41 PM
030-17 | 18/04/2018 at 2:41 PM | 18/04/2018 at 2:44 PM
030-17 | 28/03/2018 at 10:30 AM | 9/04/2018 at 10:49 AM
030-17 | 9/04/2018 at 10:49 AM | 12/04/2018 at 4:44 PM
032-17 | 16/04/2018 at 1:04 PM | 23/04/2018 at 12:42 PM
032-17 | 16/04/2018 at 11:49 AM | 16/04/2018 at 1:04 PM
032-17 | 23/04/2018 at 12:42 PM | 24/04/2018 at 10:25 AM
032-17 | 24/04/2018 at 10:25 AM | 24/04/2018 at 11:02 AM
032-17 | 24/04/2018 at 11:02 AM | 24/04/2018 at 11:02 AM
032-17 | 24/04/2018 at 11:02 AM | 26/04/2018 at 7:29 AM
032-17 | 26/04/2018 at 10:07 AM | 26/04/2018 at 11:38 AM
032-17 | 26/04/2018 at 11:38 AM | 26/04/2018 at 5:10 PM
032-17 | 26/04/2018 at 5:10 PM | 27/04/2018 at 10:19 AM
032-17 | 26/04/2018 at 7:29 AM | 26/04/2018 at 10:07 AM
032-17 | 27/04/2018 at 10:19 AM | 27/04/2018 at 11:44 AM
034-17 | 1/03/2018 at 3:04 PM | 2/03/2018 at 12:28 PM
034-17 | 22/02/2018 at 2:30 PM | 26/02/2018 at 10:01 AM
034-17 | 26/02/2018 at 10:01 AM | 27/02/2018 at 10:15 AM
034-17 | 27/02/2018 at 10:15 AM | 27/02/2018 at 10:23 AM
034-17 | 27/02/2018 at 10:23 AM | 27/02/2018 at 10:26 AM
034-17 | 27/02/2018 at 10:26 AM | 27/02/2018 at 10:33 AM
034-17 | 27/02/2018 at 10:33 AM | 27/02/2018 at 2:03 PM
034-17 | 27/02/2018 at 2:03 PM | 1/03/2018 at 3:04 PM
035-17 | 1/06/2018 at 4:35 PM | 1/06/2018 at 4:35 PM
035-17 | 1/06/2018 at 4:35 PM | 4/06/2018 at 12:33 PM
035-17 | 30/05/2018 at 10:10 AM | 30/05/2018 at 10:10 AM
035-17 | 30/05/2018 at 10:10 AM | 30/05/2018 at 8:50 PM
035-17 | 30/05/2018 at 8:50 PM | 30/05/2018 at 8:50 PM
035-17 | 30/05/2018 at 8:50 PM | 31/05/2018 at 3:37 PM
035-17 | 31/05/2018 at 3:37 PM | 31/05/2018 at 5:02 PM
035-17 | 31/05/2018 at 5:02 PM | 1/06/2018 at 4:35 PM
035-17 | 4/06/2018 at 12:33 PM | 4/06/2018 at 2:50 PM
035-17 | 4/06/2018 at 2:50 PM | 4/06/2018 at 3:12 PM
035-17 | 4/06/2018 at 3:12 PM | 4/06/2018 at 4:22 PM
042-17 | 1/06/2018 at 11:13 AM | 4/06/2018 at 1:22 PM
042-17 | 22/05/2018 at 3:33 PM | 23/05/2018 at 12:05 PM
042-17 | 23/04/2018 at 3:55 PM | 22/05/2018 at 3:33 PM
042-17 | 23/05/2018 at 12:05 PM | 24/05/2018 at 9:46 PM
042-17 | 24/05/2018 at 9:46 PM | 24/05/2018 at 9:47 PM
042-17 | 24/05/2018 at 9:47 PM | 25/05/2018 at 4:13 PM
042-17 | 25/05/2018 at 4:13 PM | 31/05/2018 at 9:14 AM
042-17 | 31/05/2018 at 10:34 AM | 1/06/2018 at 11:13 AM
042-17 | 31/05/2018 at 9:14 AM | 31/05/2018 at 10:34 AM
042-17 | 4/06/2018 at 1:22 PM | 4/06/2018 at 4:05 PM
042-17 | 4/06/2018 at 4:05 PM | 4/06/2018 at 4:54 PM
048-17 | 26/04/2018 at 8:25 AM | 26/06/2018 at 1:23 PM
048-17 | 26/06/2018 at 1:23 PM | 26/06/2018 at 8:57 PM
048-17 | 26/06/2018 at 8:57 PM | 27/06/2018 at 8:14 AM
048-17 | 27/06/2018 at 11:26 AM | 27/06/2018 at 12:56 PM
048-17 | 27/06/2018 at 12:56 PM | 28/06/2018 at 12:27 PM
048-17 | 27/06/2018 at 8:14 AM | 27/06/2018 at 11:26 AM
048-17 | 28/06/2018 at 12:27 PM | 4/07/2018 at 8:55 AM
048-17 | 4/07/2018 at 8:55 AM | 4/07/2018 at 9:01 AM
048-17 | 4/07/2018 at 9:01 AM | 5/07/2018 at 8:31 AM
048-17 | 5/07/2018 at 3:07 PM | 5/07/2018 at 4:25 PM
048-17 | 5/07/2018 at 8:31 AM | 5/07/2018 at 3:07 PM