Counting occurrences in one single cell

Copper Contributor

What formula is used to count only certain dates within one cell when there are several dates within that cell? Example, I am wanting to count the occurrence of February dates in single cells (to count absent days for a report). Example cell would contain 09/12; 10/11; 10/30; 01/15; 02/01; 02/02. The answer should be 2 for this cell example, but when I use the =Len-Substitute function, I get 0. I used a wildcard to capture all dates in February like this: 02/*. 

1 Reply

@Kelly_mohr 

With such a value in A1:

 

=(LEN(A1)-LEN(SUBSTITUTE(A1,"02/","")))/LEN("02/")