Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOKUP BETWEEN 2 DATES
I have a sports roster to keep up to date. I need to always have the kids
current age bracket updated. How can I return an age group based on their dob? The problem is there are 9 age groups and excel won't let me do that many nested if statements. It would be something like this the first age group range would be: if dob8/1/98 & dob < 7/31/99 then age group = u8 name dob age group john smith 7/1/00 ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using dates for lookup | Excel Worksheet Functions | |||
Lookup between two dates | Excel Worksheet Functions | |||
Lookup and dates | Excel Discussion (Misc queries) | |||
Lookup between dates | Excel Discussion (Misc queries) | |||
Lookup a date between other dates | Excel Worksheet Functions |