If statements for date of birth

**ajh19742000** · 10-17-2018, 05:52 AM

Hello.
I have a list of date of births which I wish to place into the following categories depending on the year they were born
Category Year Born
18-21- 2000-1997
22-25- 1996-1993
26-35- 1992-1983
35+ - 1982 & over

So in cell A1 where the date of birth is, in cell B2 I would like the category eg, 18-21. Would this be a IF statement and if so can you give me the formula?
Any help appreciated

**AliGW** · 10-17-2018, 05:59 AM

A basic LOOKUP will suffice. In B1 copied down:

=LOOKUP(YEAR(A1),{0,1983,1993,1997,2001},{"35+","26-35","22-25","18-21","Under-18"})

**Special-K** · 10-17-2018, 06:00 AM

=lookup(year(a1),{0,1983,1993,1997},{"35+","26-35","22-25","18-21"})

**ravishankar** · 10-17-2018, 06:07 AM

col B = =YEAR(TODAY())-YEAR($A1)and drag it down to the last row. In cell J2 paste the following table
< Group1
18 Group2
21 Group3
25 Group4
35 Group5
> Group6

In col C insert the formula : =VLOOKUP($B1,$J$2:$K$7,2,TRUE)
Modify parameters to suit your needs
Ravi shankar

If statements for date of birth

LinkBack

Thread Tools

Rate This Thread

Display

If statements for date of birth

Re: If statements for date of birth

Re: If statements for date of birth

Re: If statements for date of birth

Thread Information

Users Browsing this Thread

Similar Threads

Date of Birth/Age/Today's Date and Blank Cells

Formula for calculating the date a person will be a certain date from their date of birth

Work out Term of Birth by Date of Birth

Formulas Calculating Age based on Date of Birth & Date of Death

How to find the date of retirement if date of birth is 1-April-1980

Converting Date of Birth to 'Term of Birth'

[SOLVED] formula to calculate age using birth date and current date

Bookmarks

Bookmarks

Posting Permissions