I have two columns Start Date and End Date and a third column Working Days which defines the exact days of the week during which a person works (Monday, Tuesday, Wednesday, etc.).
I’d like a column to calculate the number of occurrences of any particular day or days within the date range defined by Start Date and End Date.
Example
| Start Date | End Date | Working Days | Total Work Days |
|---|---|---|---|
| 4/15/2018 | 5/15/2018 | Monday | 5 |
| 4/15/2018 | 5/15/2018 | Wednesday | 4 |
| 4/15/2018 | 5/15/2018 | Thursday | 4 |
| 4/15/2018 | 5/15/2018 | Monday, Wednesday, Thursday |
13 |

