So this is a little strange and I am having difficulty figuring out how to calculate these numbers. I have multiple sheets with active dates on them under this code:

=(IF(J18="",0,DATEDIF(J18,TODAY(),"md")&" days , "&DATEDIF(J18,TODAY(),"ym")&" months, "&DATEDIF(J18,TODAY(),"y")&" years

This gives me a current break down of months days and years a project is running in a single cell.

Then on a different sheet I want a running total of the projects that are 0-2 months old, 3-5 months old, 6-8 months old, 9-11 months old, and then a year and older. So I did this formula for counting one of the months.

=+SUM(COUNTIF(January!N17:N4010,"*6 months*") which works great, the problem is if something is 1 year and 6 months old or 2 years and 6 months old it is also counted in this number. Is there a way I can just calculate the ones that are 6 months and not those that are 1 year and 6 months etc.

Thanks
Jason