I want to get a text string based on a child's age, such as "3 y, 6 m, 2 d" which I've already managed to generate in cell B6 using =DATEDIF(A6,"8/1/"& B4,"y")&" years, "&DATEDIF(A6,"8/1/"& B4,"ym")&" months, "&DATEDIF(A6,"8/1/"& B4,"md")&" days".
If the child's age is 0 years, 0 months, 1 days to 2 years, 5 months, 31 days, I want it to return "EHS" in cell D6.
If the child's age is 2 years, 6 months, 0 days to 2 years, 11 months, 31 days, I want it to return "Gap" in cell D6.
If the child's age is 3 years, 0 months, 0 days to 4 years, 11 months, 31 days, I want it to return "HS" in cell D6.
And if the child's age is 5 years, 0 months, 0 days or older I want it to return "Age Inelligible" in cell D6.
I'm thinking database, but I am self-taught and lost at the moment. Any help would be greatly appreciated.
Bookmarks