Forum Discussion
Heather Shininger
Apr 17, 2018Copper Contributor
Excel Formula
I have a cell that I calculated the age with years, months and days. I now need to count how many of those cells meet certain criteria, i.e. 0 years, 0 month, 27 days. What is a formula that I can use that will count with all the criteria from the cell?
1 Reply
- SergeiBaklanDiamond Contributor
Hi Heather,
It depends on how do you present the age. Years, months and days are numbers in separate cells, or that's a string in one cell separated by something, or what. Better if you attache small sample.