Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

excel formula

I an looking for an excel formula

in my xls I have a birthdate field column a, I would like column b to be

U9 if column A > 8/31/2003
U11 if column A > 8/31/2001 and < 9/1/2003
U13 if column A > 8/31/1999 and < 9/1/2001
U15 if column A > 8/31/1997 and < 9/1/1999
HS if column A < 9/1/1999
Avatar of byundt
byundt
Flag of United States of America image

You might try a formula like:
=IF(A1="","",LOOKUP(A1, DATE({0,1997,1999,2001,2003},9,1),{"HS","U15","U13","U11","U9"}))

It wasn't clear what the criteria for HS should be from the question. I assumed that it was before 9/1/1997, and that you wrote < 9/1/1999 in error.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial