Hi guys.

I need to calculate the age difference in (Years, Months, Days) between Date of Birth (ex. 11-Nov-2007) and a given date (ex. 01-Dec-2013) and how to use LOOKUP function to identify the age group they belong to (ex. 5-7 yrs old, 8 yrs old, 9 yrs old). Can this be done? and what is the formula?

Thank you.