Creating a chart out of text separated by commas

Part of my problem is that I do not have the vocabulary to search for help. So my apologies if I overlooked this exact question in my search.

I have a online survey I am administering, and one of the questions is "Which upcoming Saturdays are you available? (Check all that apply)"
the output, which ends up in a single cell is something like this:
"September 15, September 22, September 29, October 6, October 13, October 20, October 27"

I am wondering how to easily make a bar chart out of this sort of text data separated by commas.
The best I have come up with is manually separating them out into their own columns, then using count and charting from that.


I have attached a sample file.

Thank you in advance.

-MC

Does the attached do what you want?

For the 3 responses which had only a single date, I've had to change the entry to a text format rather than a pure date. I've put the first Saturday in cell C1 (in text format) and then in D1 I have this formula:

=TEXT(DATEVALUE(RIGHT(C1,2)&" "&LEFT(C1,3)&" "&YEAR(TODAY()))+7,"mmmm d")

which can be copied across to give subsequent Saturdays in Text format (or you could just type these yourself - but set the format to Text first if you do).

Then I have used conditional formatting (green) to show people's availability, with this CF formula for C2:

=ISNUMBER(SEARCH(C$1,$A2))

with the whole block selected.

Hope this helps.

Pete

Wow, you just blew my mind. Thank you. Now I have to go meditate on this...