Forum Discussion

Heather Shininger's avatar
Heather Shininger
Copper Contributor
Apr 17, 2018

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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.

Resources