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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=IF(A1="","",LOOKUP(A1, DATE({0,1997,1999,2001,200
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.