How to Count how many date occurances inside a cell AND a range of cells?

B3 to I3 (8 difference cells) may or may not contain dates. If there is a date, it's in the format of XX/XX/XXXX. If there is no date, then the cell is blank.
In addition, inside any one of those 8 cells, there may be MORE THAN ONE date separated by a row.

How can I get J3 to count how many times there is a date? (In case it matters, the date format is XX/XX/XXXX).


Example 1: Only I3 has data, and it has two dates, separated by a row inside of the cell.
Example 2: B3 has 2 dates separated within the cell by a row, and C3 has one date.

for the J3 formula, Example 1 should give me an answer of 2, and Example 2 should give me an answer of 3.

What formula do i use to capture this count of dates?

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Originally Posted by alansidman

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Ok, no problem alan. I have uploaded an example. Column J is what the current formula is (and the wrong answer), and Column K shows the DESIRED ANSWER.

Click on the formula and then click on the Evaluate Icon on the ribbon to see how the formula works.