Hi all,
I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.'
See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May? The answer I'm looking for via formula is 3 since the other Thursdays are duplicates.
Also note, I won't have the helper column #2 below in my report (Day of week) - I just put that in for clarity.
Many thanks for your time!
<tbody>
</tbody>
James
I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.'
See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May? The answer I'm looking for via formula is 3 since the other Thursdays are duplicates.
Also note, I won't have the helper column #2 below in my report (Day of week) - I just put that in for clarity.
Many thanks for your time!
Date | Day of week (info only) | Count |
Jan 11, 2018 | Thursday | 1 |
Jan 11, 2018 | Thursday | |
Feb 7, 2018 | Wednesday | |
Feb 8, 2018 | Thursday | 1 |
Feb 8, 2018 | Thursday | |
Feb 22, 2018 | Thursday | 1 |
Feb 22, 2018 | Thursday |
<tbody>
</tbody>
James