Forum Discussion

Kelly_mohr's avatar
Kelly_mohr
Copper Contributor
Feb 07, 2023

Counting occurrences in one single cell

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/*. 

Resources