Age group formula when you days, months, and years in TEXT

[Wally309]

Formula to group age with days, months, and years. Example: 1 day baby, 1 month old, and 1 year old need grouped in 0-18

 

[Peter_SSs]

Please post (preferably with XL2BB) 5-10 rows of sample data and the expected results so that we can get a good idea of just what you have, where it is and what the expected results are and where they are.

 

[Wally309]

 

[Peter_SSs]

What would the results actually look like for that particular sample data & where would they be?

If this is not feasible with formulas, would a vba approach be acceptable?

.. and I cannot copy from an image like that to test. Can you use XL2BB?