| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Birth Date in Range
I have a column with birth dates. I want to assign the individual
birth dates to age groups (21-30, 31-40, etc.). How can I get Excel to calculate if a birth date falls into a date range, and have it assign a value. Is there a function that I could do that is like =IF(C2 IS BETWEEN 6/20/1927 AND 6/20/1937,"X") where C2 is the individual's birth date, and "X" is placed in the column to symbolize that the individual falls into that age group. ?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Date of Birth from a ID Number | Excel Worksheet Functions | |||
| How do you calculate age from just having a Date of Birth? | Excel Discussion (Misc queries) | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| ages/date of birth | Excel Worksheet Functions | |||
| Converting Date of Birth to Age | Excel Worksheet Functions | |||
Threaded Mode
