hi,
im after a count if that brings back the CL's from the third column after todays date

WorkDate FINISHTIME Shift
1-Apr-2022 22:00:00 L
2-Apr-2022 00:00:00 -
3-Apr-2022 00:00:00 -
4-Apr-2022 00:00:00 H
5-Apr-2022 00:00:00 H
6-Apr-2022 00:00:00 H
7-Apr-2022 00:00:00 H
8-Apr-2022 00:00:00 H
9-Apr-2022 00:00:00 -
10-Apr-2022 00:00:00 HS
11-Apr-2022 14:00:00 D
12-Apr-2022 22:00:00 L
13-Apr-2022 22:00:00 L
14-Apr-2022 22:00:00 L
15-Apr-2022 00:00:00 -
16-Apr-2022 00:00:00 -
17-Apr-2022 00:00:00 -
18-Apr-2022 17:00:00 S
19-Apr-2022 00:00:00 CD
20-Apr-2022 14:00:00 E
21-Apr-2022 14:00:00 E
22-Apr-2022 00:00:00 W
23-Apr-2022 00:00:00 -
24-Apr-2022 00:00:00 -
25-Apr-2022 22:00:00 L
26-Apr-2022 22:00:00 L
27-Apr-2022 22:00:00 L
28-Apr-2022 22:00:00 L
29-Apr-2022 22:00:00 L
30-Apr-2022 00:00:00 -
1-May-2022 00:00:00 -
2-May-2022 00:00:00 -
3-May-2022 14:00:00 E
4-May-2022 14:00:00 E
5-May-2022 14:00:00 E
6-May-2022 14:00:00 E
7-May-2022 00:00:00 -
8-May-2022 17:00:00 SL
9-May-2022 00:00:00 W
10-May-2022 22:00:00 L
11-May-2022 22:00:00 L
12-May-2022 22:00:00 L
13-May-2022 00:00:00 CL
14-May-2022 00:00:00 -
15-May-2022 00:00:00 -
16-May-2022 14:00:00 E
17-May-2022 14:00:00 E
18-May-2022 14:00:00 E
19-May-2022 14:00:00 E
20-May-2022 14:00:00 E
21-May-2022 00:00:00 -
22-May-2022 00:00:00 -
23-May-2022 22:00:00 L
24-May-2022 22:00:00 L
25-May-2022 22:00:00 L
26-May-2022 22:00:00 L
27-May-2022 22:00:00 L
28-May-2022 00:00:00 -
29-May-2022 00:00:00 -
30-May-2022 14:00:00 D
31-May-2022 14:00:00 D
1-Jun-2022 00:00:00 W
2-Jun-2022 00:00:00 -
3-Jun-2022 00:00:00 -
4-Jun-2022 00:00:00 -
5-Jun-2022 00:00:00 -
6-Jun-2022 00:00:00 H
7-Jun-2022 00:00:00 H
8-Jun-2022 00:00:00 H
9-Jun-2022 00:00:00 H
10-Jun-2022 00:00:00 H
11-Jun-2022 00:00:00 -
12-Jun-2022 00:00:00 HS
13-Jun-2022 14:00:00 E
14-Jun-2022 14:00:00 E
15-Jun-2022 14:00:00 E
16-Jun-2022 00:00:00 CD
17-Jun-2022 14:00:00 E
18-Jun-2022 00:00:00 -
19-Jun-2022 17:00:00 SL
20-Jun-2022 22:00:00 L
21-Jun-2022 22:00:00 L
22-Jun-2022 22:00:00 L
23-Jun-2022 22:00:00 L
24-Jun-2022 22:00:00 L
25-Jun-2022 00:00:00 -
26-Jun-2022 17:00:00 SE
27-Jun-2022 00:00:00 W
28-Jun-2022 14:00:00 E
29-Jun-2022 14:00:00 E
30-Jun-2022 14:00:00 E
1-Jul-2022 14:00:00 E
2-Jul-2022 00:00:00 -
3-Jul-2022 00:00:00 -
4-Jul-2022 22:00:00 L
5-Jul-2022 00:00:00 CL
6-Jul-2022 22:00:00 L
7-Jul-2022 22:00:00 L
8-Jul-2022 22:00:00 L
9-Jul-2022 00:00:00 -
10-Jul-2022 17:00:00 SE
11-Jul-2022 14:00:00 E
12-Jul-2022 14:00:00 E
13-Jul-2022 14:00:00 E
14-Jul-2022 14:00:00 E
15-Jul-2022 00:00:00 W
16-Jul-2022 00:00:00 -
17-Jul-2022 00:00:00 -
18-Jul-2022 00:00:00 H
19-Jul-2022 00:00:00 H
20-Jul-2022 00:00:00 H
21-Jul-2022 00:00:00 H
22-Jul-2022 00:00:00 H
23-Jul-2022 00:00:00 -
24-Jul-2022 00:00:00 HS
25-Jul-2022 14:00:00 E
26-Jul-2022 14:00:00 E
27-Jul-2022 14:00:00 E
28-Jul-2022 14:00:00 E
29-Jul-2022 14:00:00 E
30-Jul-2022 00:00:00 -
31-Jul-2022 17:00:00 SL
1-Aug-2022 22:00:00 L
2-Aug-2022 00:00:00 W
3-Aug-2022 22:00:00 L
4-Aug-2022 22:00:00 L
5-Aug-2022 22:00:00 L
6-Aug-2022 00:00:00 -
7-Aug-2022 17:00:00 SE
8-Aug-2022 14:00:00 E
9-Aug-2022 14:00:00 E
10-Aug-2022 14:00:00 E
11-Aug-2022 00:00:00 W


12-Aug-2022 00:00:00 CD
13-Aug-2022 00:00:00 -
14-Aug-2022 00:00:00 -
15-Aug-2022 22:00:00 L
16-Aug-2022 22:00:00 L
17-Aug-2022 22:00:00 L
18-Aug-2022 22:00:00 L
19-Aug-2022 22:00:00 L
20-Aug-2022 00:00:00 -
21-Aug-2022 00:00:00 -
22-Aug-2022 14:00:00 E
23-Aug-2022 14:00:00 E
24-Aug-2022 14:00:00 E
25-Aug-2022 14:00:00 E
26-Aug-2022 14:00:00 E
27-Aug-2022 00:00:00 -
28-Aug-2022 00:00:00 -
29-Aug-2022 17:00:00 S
30-Aug-2022 22:00:00 L
31-Aug-2022 00:00:00 CL
1-Sep-2022 00:00:00 W
2-Sep-2022 22:00:00 L
3-Sep-2022 00:00:00 -
4-Sep-2022 00:00:00 -
5-Sep-2022 14:00:00 E
6-Sep-2022 14:00:00 E
7-Sep-2022 14:00:00 E
8-Sep-2022 14:00:00 E
9-Sep-2022 14:00:00 E
10-Sep-2022 00:00:00 -
11-Sep-2022 17:00:00 SL
12-Sep-2022 00:00:00 W
13-Sep-2022 22:00:00 L
14-Sep-2022 22:00:00 L
15-Sep-2022 22:00:00 L
16-Sep-2022 22:00:00 L
17-Sep-2022 00:00:00 -
18-Sep-2022 00:00:00 -
19-Sep-2022 14:00:00 E
20-Sep-2022 14:00:00 E
21-Sep-2022 14:00:00 E
22-Sep-2022 14:00:00 E
23-Sep-2022 14:00:00 E
24-Sep-2022 00:00:00 -
25-Sep-2022 17:00:00 SL
26-Sep-2022 22:00:00 L
27-Sep-2022 00:00:00 W
28-Sep-2022 22:00:00 L
29-Sep-2022 22:00:00 L
30-Sep-2022 22:00:00 L
1-Oct-2022 00:00:00 -
2-Oct-2022 00:00:00 -
3-Oct-2022 14:00:00 E
4-Oct-2022 00:00:00 CD
5-Oct-2022 14:00:00 E
6-Oct-2022 14:00:00 E
7-Oct-2022 14:00:00 E
8-Oct-2022 00:00:00 -
9-Oct-2022 17:00:00 SL
10-Oct-2022 22:00:00 L
11-Oct-2022 22:00:00 L
12-Oct-2022 22:00:00 L
13-Oct-2022 22:00:00 L
14-Oct-2022 00:00:00 W
15-Oct-2022 00:00:00 -
16-Oct-2022 00:00:00 -
17-Oct-2022 00:00:00 H
18-Oct-2022 00:00:00 H
19-Oct-2022 00:00:00 H
20-Oct-2022 00:00:00 H
21-Oct-2022 00:00:00 H
22-Oct-2022 00:00:00 -
23-Oct-2022 00:00:00 HS
24-Oct-2022 22:00:00 L
25-Oct-2022 22:00:00 L
26-Oct-2022 22:00:00 L
27-Oct-2022 22:00:00 L
28-Oct-2022 00:00:00 CL
29-Oct-2022 00:00:00 -
30-Oct-2022 17:00:00 SE
31-Oct-2022 14:00:00 E
1-Nov-2022 14:00:00 E
2-Nov-2022 00:00:00 W
3-Nov-2022 14:00:00 E
4-Nov-2022 14:00:00 E
5-Nov-2022 00:00:00 -
6-Nov-2022 00:00:00 -
7-Nov-2022 22:00:00 L
8-Nov-2022 22:00:00 L
9-Nov-2022 22:00:00 L
10-Nov-2022 22:00:00 L
11-Nov-2022 22:00:00 L
12-Nov-2022 00:00:00 -
13-Nov-2022 00:00:00 -
14-Nov-2022 00:00:00 CD
15-Nov-2022 14:00:00 E
16-Nov-2022 14:00:00 E
17-Nov-2022 14:00:00 E
18-Nov-2022 14:00:00 E
19-Nov-2022 00:00:00 -
20-Nov-2022 00:00:00 -
21-Nov-2022 22:00:00 L
22-Nov-2022 22:00:00 L
23-Nov-2022 22:00:00 L
24-Nov-2022 22:00:00 L
25-Nov-2022 22:00:00 L
26-Nov-2022 00:00:00 -
27-Nov-2022 17:00:00 SE
28-Nov-2022 14:00:00 E
29-Nov-2022 14:00:00 E
30-Nov-2022 14:00:00 E
1-Dec-2022 14:00:00 E
2-Dec-2022 00:00:00 W
3-Dec-2022 00:00:00 -
4-Dec-2022 00:00:00 -
5-Dec-2022 22:00:00 L
6-Dec-2022 00:00:00 CL
7-Dec-2022 22:00:00 L
8-Dec-2022 22:00:00 L
9-Dec-2022 22:00:00 L
10-Dec-2022 00:00:00 -
11-Dec-2022 00:00:00 -
12-Dec-2022 14:00:00 E
13-Dec-2022 14:00:00 E
14-Dec-2022 14:00:00 E
15-Dec-2022 14:00:00 E
16-Dec-2022 14:00:00 E
17-Dec-2022 00:00:00 -
18-Dec-2022 17:00:00 SL
19-Dec-2022 22:00:00 L
20-Dec-2022 00:00:00 W
21-Dec-2022 22:00:00 L
22-Dec-2022 22:00:00 L
23-Dec-2022 22:00:00 L
24-Dec-2022 00:00:00 -
25-Dec-2022 00:00:00 -
26-Dec-2022 00:00:00 -
27-Dec-2022 00:00:00 -
28-Dec-2022 14:00:00 E
29-Dec-2022 14:00:00 E
30-Dec-2022 14:00:00 E
31-Dec-2022 00:00:00 -
1-Jan-2023 00:00:00 -
2-Jan-2023 00:00:00 -
3-Jan-2023 22:00:00 L
4-Jan-2023 22:00:00 L
5-Jan-2023 22:00:00 L
6-Jan-2023 00:00:00 CL
7-Jan-2023 00:00:00 -
8-Jan-2023 17:00:00 SE
9-Jan-2023 14:00:00 E
10-Jan-2023 00:00:00 W
11-Jan-2023 14:00:00 E
12-Jan-2023 14:00:00 E
13-Jan-2023 14:00:00 E
14-Jan-2023 00:00:00 -
15-Jan-2023 00:00:00 -
16-Jan-2023 22:00:00 L
17-Jan-2023 22:00:00 L
18-Jan-2023 00:00:00 H
19-Jan-2023 22:00:00 L
20-Jan-2023 22:00:00 L
21-Jan-2023 00:00:00 -
22-Jan-2023 17:00:00 SE
23-Jan-2023 00:00:00 CD
24-Jan-2023 14:00:00 E
25-Jan-2023 14:00:00 E
26-Jan-2023 14:00:00 E
27-Jan-2023 00:00:00 W
28-Jan-2023 00:00:00 -
29-Jan-2023 00:00:00 -
30-Jan-2023 22:00:00 L
31-Jan-2023 22:00:00 L
1-Feb-2023 22:00:00 L
2-Feb-2023 00:00:00 H
3-Feb-2023 22:00:00 L
4-Feb-2023 00:00:00 -
5-Feb-2023 00:00:00 -
6-Feb-2023 14:00:00 E
7-Feb-2023 14:00:00 E
8-Feb-2023 14:00:00 E
9-Feb-2023 14:00:00 E
10-Feb-2023 14:00:00 E
11-Feb-2023 00:00:00 -
12-Feb-2023 17:00:00 SL
13-Feb-2023 22:00:00 L
14-Feb-2023 00:00:00 CL
15-Feb-2023 22:00:00 L
16-Feb-2023 22:00:00 L
17-Feb-2023 00:00:00 W
18-Feb-2023 00:00:00 -
19-Feb-2023 00:00:00 -
20-Feb-2023 00:00:00 H
21-Feb-2023 00:00:00 H
22-Feb-2023 00:00:00 H
23-Feb-2023 00:00:00 H
24-Feb-2023 00:00:00 H
25-Feb-2023 00:00:00 -
26-Feb-2023 00:00:00 HS
27-Feb-2023 22:00:00 L
28-Feb-2023 22:00:00 L
1-Mar-2023 22:00:00 L
2-Mar-2023 22:00:00 L
3-Mar-2023 22:00:00 L
4-Mar-2023 00:00:00 -
5-Mar-2023 00:00:00 -
6-Mar-2023 14:00:00 E
7-Mar-2023 14:00:00 E
8-Mar-2023 14:00:00 E
9-Mar-2023 14:00:00 E
10-Mar-2023 00:00:00 H
11-Mar-2023 00:00:00 -
12-Mar-2023 00:00:00 -
13-Mar-2023 22:00:00 L
14-Mar-2023 22:00:00 L
15-Mar-2023 22:00:00 L
16-Mar-2023 22:00:00 L
17-Mar-2023 22:00:00 L
18-Mar-2023 00:00:00 -
19-Mar-2023 00:00:00 -
20-Mar-2023 00:00:00 CD
21-Mar-2023 14:00:00 E
22-Mar-2023 14:00:00 E
23-Mar-2023 14:00:00 E
24-Mar-2023 14:00:00 E
25-Mar-2023 00:00:00 -
26-Mar-2023 00:00:00 -
27-Mar-2023 22:00:00 L
28-Mar-2023 22:00:00 L
29-Mar-2023 22:00:00 L
30-Mar-2023 22:00:00 L
31-Mar-2023 22:00:00 L

Thanks

Regards
Lee Watson

where Workdate will be "[Workdate]" and Shift will be "[Shift]" in case you define your table as Table,
or Workdate and Shift will be Dynamic Named Ranges you have defined,
or they will be dataranges like "A2:A100", "D2: D100".

@loopy
In the future please post an Excel sheet. It's much easier than to have to create one ourselves ( no pics please). Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post