Count Dates within a cell

[GreyFox8991]

Hello excel community,

I have some data with a varying amount of dates in each cell. What I am looking for is a possible formula to count the amount of dates within the present cell. I will include some test data for context in a screenshot.

I would like the end result to be:

if cell B2 has two dates formatted in mm/dd/yyyy or date format, then the count of dates would be 2
if cell B3 has 5 dates formatted in mm/dd/yyyy or date format, then the count of dates would be 5.

Any help would be greatly appreciated.

 

[Joe4]

Looks like we should be able to just count the number of commas and add 1.
So for an entry in cell B2, the formula would look like:

=LEN(B2)-LEN(SUBSTITUTE(B2,",",""))+1

 

[GreyFox8991]

Thank you Joe, this is a great solution. I will mark this as a solution. Thank you so much for your help.

 

[Joe4]

You are welcome.
Glad I was able to help!