# Calculate how many occurrences in a given month, when multiple dates are in single cell

1. ## Calculate how many occurrences in a given month, when multiple dates are in single cell

I have a list of teachers requesting days off, and I want to run a total of how many subs I will need for each teacher in a given month, but the dates are listed in a text string in one cell. I am trying to get a formula that will split the dates, and then count number of occurrences in each month.

For example, can I calculate how many days in November 'Jess' has requested off,

Name Sub Dates
John Yes 10/25/19, 11/12/19
Max No 11/12/19
Jess Yes 10/15/19,11/15/19,12/15/19
Max No 11/12/19
Jess Yes 11/13/19,12/15/19

Thank you!

2. ## Re: Calculate how many occurrences in a given month, when multiple dates are in single cel

with the above table being in A1:C6 (with row being headers) something like the below *might* work:

Formula:
`Please Login or Register  to view this content.`

where E2 holds Name of interest (e.g. Jess), and F1 the Month of interest - e.g. Nov-19
obviously if you add more names in Col E, and months in row 1 (G1 etc) you can copy across to generate more results.

I say *might* as there appear to be some duplicates in your dates and unclear to me, given lack of expected results, as to whether or not these need to be ignored

as-is the above, for Jess, would generate 1 day in Oct-19, 2 days in Nov-19 & Dec-19.

There are currently 1 users browsing this thread. (0 members and 1 guests)