Kjandersen333
New Member
- Joined
- Jun 25, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
What formula do i use to count 2 or more consecutive days?
Can I set this up in a pivot table?
Or just add a column next to my pivot table?
Can I set this up in a pivot table?
Or just add a column next to my pivot table?
| Row Labels |
| 01-001 |
| Oct 4, 2021, 1:34:05 PM |
| Oct 4, 2021, 1:35:17 PM |
| Oct 4, 2021, 1:35:43 PM |
| 01-002 |
| Apr 10, 2022, 8:35:24 PM |
| Apr 10, 2022, 9:08:06 AM |
| Apr 11, 2022, 9:25:56 PM |
| Apr 13, 2022, 4:48:48 PM |
| Apr 13, 2022, 4:49:08 PM |
| Apr 14, 2022, 11:44:34 AM |
| Apr 14, 2022, 8:23:07 AM |
| Apr 14, 2022, 8:36:46 PM |
| Apr 15, 2022, 9:46:15 AM |
| Apr 16, 2022, 10:20:49 AM |
| Apr 16, 2022, 11:56:33 AM |
| Apr 16, 2022, 5:40:19 PM |
| Apr 16, 2022, 9:54:08 PM |
| Apr 17, 2022, 1:41:43 PM |
| Apr 18, 2022, 2:05:31 PM |
| Apr 19, 2022, 11:56:43 AM |
| Apr 19, 2022, 9:35:29 AM |
| Apr 2, 2022, 9:49:09 AM |
| Apr 21, 2022, 3:19:19 PM |
| Apr 21, 2022, 6:55:14 AM |
| Apr 22, 2022, 6:31:13 AM |
| Apr 22, 2022, 9:59:51 AM |
| Apr 23, 2022, 6:50:33 AM |
| Apr 24, 2022, 10:21:50 AM |
| Apr 25, 2022, 10:10:28 AM |
| Apr 26, 2022, 8:58:01 AM |
| Apr 30, 2022, 2:40:31 PM |
| Apr 5, 2022, 11:21:35 AM |
| Apr 5, 2022, 2:53:30 PM |
| Apr 6, 2022, 3:35:02 PM |
| Apr 7, 2022, 4:58:33 PM |
| Apr 7, 2022, 7:23:00 PM |
| Apr 8, 2022, 12:11:14 PM |
| Apr 8, 2022, 7:13:24 AM |
| Feb 1, 2022, 9:21:50 PM |
| Feb 10, 2022, 3:17:46 PM |
| Feb 11, 2022, 5:02:51 PM |
| Feb 2, 2022, 7:35:41 AM |
| Jun 1, 2022, 4:40:37 PM |
| Jun 15, 2022, 12:30:56 PM |
| Jun 16, 2022, 9:02:16 PM |
| Jun 18, 2022, 2:33:42 PM |
| Jun 23, 2022, 12:09:16 PM |
| Jun 6, 2022, 9:27:42 PM |
| Jun 8, 2022, 10:36:03 AM |
| Jun 8, 2022, 2:46:30 PM |
| Mar 19, 2022, 10:29:40 AM |
| Mar 19, 2022, 9:41:48 AM |
| Mar 21, 2022, 1:42:58 PM |
| Mar 23, 2022, 11:26:45 AM |
| Mar 23, 2022, 3:42:04 PM |
| Mar 23, 2022, 8:39:48 PM |
| Mar 24, 2022, 7:10:54 AM |
| Mar 24, 2022, 7:32:47 PM |
| Mar 25, 2022, 4:28:42 PM |
| Mar 26, 2022, 10:10:19 AM |
| Mar 26, 2022, 9:11:06 AM |
| Mar 27, 2022, 5:22:21 PM |
| Mar 29, 2022, 11:40:53 AM |
| Mar 31, 2022, 11:44:59 AM |
| Mar 31, 2022, 6:22:37 PM |
| May 1, 2022, 11:05:19 AM |
| May 11, 2022, 11:41:16 AM |
| May 12, 2022, 7:30:01 AM |
| May 12, 2022, 9:30:05 PM |
| May 13, 2022, 8:53:29 AM |
| May 14, 2022, 11:19:41 AM |
| May 14, 2022, 4:45:28 PM |
| May 16, 2022, 7:04:00 PM |
| May 16, 2022, 9:13:29 PM |
| May 17, 2022, 11:10:14 AM |
| May 19, 2022, 7:02:40 PM |
| May 2, 2022, 11:32:11 AM |
| May 2, 2022, 2:23:10 PM |
| May 26, 2022, 3:36:19 PM |
| May 27, 2022, 10:46:03 AM |
| May 27, 2022, 7:38:25 AM |
| May 28, 2022, 5:05:40 PM |
| May 3, 2022, 11:37:12 AM |
| May 3, 2022, 8:51:49 PM |
| May 30, 2022, 3:35:10 PM |
| May 30, 2022, 8:06:37 PM |
| May 4, 2022, 11:17:12 AM |
| May 5, 2022, 6:13:01 PM |
| May 7, 2022, 3:52:00 PM |
| 02-001 |
| Apr 1, 2021, 3:04:12 AM |
| Apr 10, 2021, 11:38:54 PM |
| Apr 13, 2021, 11:39:12 PM |
| Apr 14, 2021, 12:56:52 PM |
| Apr 18, 2021, 1:29:27 AM |
| Apr 19, 2021, 3:15:59 PM |
| Apr 2, 2021, 2:40:36 PM |
| Apr 20, 2021, 1:11:23 PM |
| Apr 23, 2021, 5:23:41 PM |
| Apr 23, 2021, 9:38:45 PM |
| Apr 24, 2021, 9:54:08 AM |
| Apr 26, 2021, 11:16:24 PM |
| Apr 27, 2021, 12:24:39 AM |
| Apr 28, 2021, 12:16:35 PM |
| Apr 28, 2021, 5:56:33 AM |
| Apr 29, 2021, 11:00:58 PM |
| Apr 29, 2021, 8:39:53 PM |
| Apr 5, 2021, 2:28:21 AM |
| Apr 5, 2021, 9:01:42 AM |
| Apr 5, 2021, 9:02:53 AM |
| Apr 5, 2021, 9:04:19 AM |
| Apr 6, 2021, 1:21:12 PM |
| Apr 8, 2021, 11:23:28 PM |
| Apr 8, 2021, 3:32:27 AM |
| Apr 8, 2021, 4:29:03 PM |
| Apr 8, 2021, 4:58:26 AM |
| Apr 8, 2021, 8:08:00 AM |
| Apr 9, 2021, 4:49:56 PM |
| Apr 9, 2021, 6:28:09 PM |
| Aug 7, 2021, 8:30:27 PM |
| Jul 12, 2021, 10:31:45 PM |
| Jul 12, 2021, 11:39:53 PM |
| Jul 2, 2021, 10:34:56 PM |
| Jul 2, 2021, 3:00:06 AM |
| Jul 24, 2021, 1:51:11 AM |
| Jul 24, 2021, 2:41:48 AM |
| Jul 26, 2021, 4:56:40 PM |
| Jul 26, 2021, 5:18:01 AM |
| Jul 3, 2021, 12:08:47 AM |
| Jul 3, 2021, 3:04:46 AM |
| Jul 31, 2021, 12:27:49 AM |
| Jun 10, 2021, 11:22:06 PM |
| Jun 13, 2021, 8:05:20 PM |
| Jun 14, 2021, 1:57:43 PM |
| Jun 14, 2021, 11:18:36 AM |
| Jun 15, 2021, 1:42:49 AM |
| Jun 19, 2021, 2:26:46 AM |
| Jun 19, 2021, 3:12:00 AM |
| Jun 2, 2021, 12:57:01 AM |
| Jun 20, 2021, 1:56:17 PM |
| Jun 29, 2021, 11:46:48 AM |
| Jun 6, 2021, 12:33:22 AM |
| Jun 6, 2021, 5:28:09 AM |
| Mar 1, 2021, 10:55:49 PM |
| Mar 1, 2021, 3:56:04 PM |
| Mar 10, 2021, 11:55:36 PM |
| Mar 10, 2021, 12:51:16 AM |
| Mar 10, 2021, 2:31:32 AM |
| Mar 11, 2021, 1:17:31 AM |
| Mar 11, 2021, 11:14:12 AM |
| Mar 11, 2021, 12:07:35 PM |
| Mar 11, 2021, 12:35:34 PM |
| Mar 11, 2021, 3:08:59 PM |
| Mar 12, 2021, 10:53:59 PM |
| Mar 12, 2021, 3:46:20 PM |
| Mar 13, 2021, 11:35:51 PM |
| Mar 13, 2021, 9:27:02 PM |
| Mar 14, 2021, 4:24:06 PM |
| Mar 14, 2021, 5:11:20 PM |
| Mar 14, 2021, 6:59:10 PM |
| Mar 14, 2021, 8:27:42 PM |
| Mar 15, 2021, 3:03:14 PM |
| Mar 15, 2021, 9:11:55 PM |
| Mar 16, 2021, 1:49:45 AM |
| Mar 16, 2021, 12:12:26 AM |
| Mar 17, 2021, 1:15:01 AM |
| Mar 17, 2021, 11:54:32 PM |
| Mar 17, 2021, 12:58:53 AM |
| Mar 18, 2021, 11:26:52 PM |
| Mar 18, 2021, 11:38:25 AM |
| Mar 18, 2021, 5:21:00 AM |
| Mar 19, 2021, 1:00:29 AM |
| Mar 2, 2021, 1:50:38 PM |
| Mar 2, 2021, 11:58:34 AM |
| Mar 21, 2021, 10:16:22 PM |
| Mar 21, 2021, 11:45:57 PM |
| Mar 21, 2021, 6:15:30 PM |
| Mar 24, 2021, 1:29:59 AM |
| Mar 26, 2021, 3:47:29 PM |
| Mar 28, 2021, 12:58:29 AM |
| Mar 29, 2021, 9:52:18 AM |
| Mar 3, 2021, 1:09:31 AM |
| Mar 3, 2021, 10:26:07 PM |
| Mar 3, 2021, 12:46:05 PM |
| Mar 4, 2021, 2:16:52 PM |
| Mar 6, 2021, 12:24:12 PM |
| Mar 6, 2021, 4:24:39 PM |
| Mar 7, 2021, 5:51:04 PM |
| Mar 9, 2021, 10:26:30 PM |
| Mar 9, 2021, 12:12:05 AM |
| Mar 9, 2021, 3:07:51 PM |
| May 12, 2021, 1:53:41 AM |
| May 12, 2021, 12:49:51 AM |
| May 14, 2021, 12:44:20 AM |
| May 16, 2021, 2:29:14 AM |
| May 17, 2021, 11:37:14 AM |
| May 18, 2021, 7:03:01 PM |
| May 21, 2021, 3:48:38 PM |
| May 21, 2021, 9:03:19 PM |
| May 22, 2021, 2:15:44 PM |
| May 24, 2021, 1:33:25 AM |
| May 31, 2021, 6:00:34 PM |
| May 4, 2021, 7:08:18 PM |
| May 7, 2021, 12:36:44 PM |
| May 7, 2021, 3:35:06 AM |
| May 9, 2021, 5:07:14 AM |
