Feb 07 2023 08:35 AM
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/*.
Feb 07 2023 11:39 AM