Forum Discussion
Kelly_mohr
Feb 07, 2023Copper Contributor
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/*.
1 Reply
Sort By