Count the rows within the cell formula

[PCRIDE]

Hi, I have a text field that is filled with updates for each time someone goes into the Ticket Tool to update a Ticket. When exporting the data it comes through all in one cell for that record.

Is there a formula or VB that can search the cell contents, look at the date and count the number of rows within a cell that has a date ? So this would have 6 updates .


6/3/18 - This is an update.

6/1/18 - This is an update.

5/27/18 - This is an update.

5/10/18 - This is an update.

4/15/18 - This is an update.

4/3/18 - This is an update.

Not sure I want to use Text to columns as there could be 25 rows or more extracting.

 

[Aladin Akyurek]

Is this what you are looking for?

=SUMPRODUCT(--ISNUMBER(LEFT(A2:A7,FIND("-",A2:A7)-1)+0))

 

[JoeMo]

If your posted sample data is all in a single cell, here's a UDF you can try (below the example of its use).

Excel Workbook
	D	E
1	6/3/18 - This is an update. 6/1/18 - This is an update. 5/27/18 - This is an update. 5/10/18 - This is an update. 4/15/18 - This is an update. 4/3/18 - This is an update.	6
Sheet5

Function CountIfDate(S As String) As Long
Dim V As Variant
V = Split(S, " ")
For i = LBound(V) To UBound(V)
    If IsDate(V(i)) Then CountIfDate = CountIfDate + 1
Next i
End Function