Labeling Generations

[zinah]

Hi,

I have list of employees and their date of birth, I need tolabel each employee with the right generation name according to the list below:

[TABLE="width: 107"]
<tbody>[TR]
[TD="width: 143, bgcolor: transparent"] Generation
[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] 1984-2002 – Millennial

[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] 1946-1964 – Baby Boomers

[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] 1965-1983 – Gen X
[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] 1946-1964 - Baby Boomers
[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] 1927-1945 – Traditionalists
[/TD]
[/TR]
[TR]
[TD="width: 143, bgcolor: transparent"] Not Available
[/TD]
[/TR]
</tbody>[/TABLE]


EE Name Date of Birth
A 1/1/1960
B 1/1/1989
C 1/1/1970
D 1/1/1995

Can you help me with sharing the right formula?

Thank you!

 

[Asala42]

I'd probably just use a nested if statement in this case. Where years are in column B:

=IF(YEAR(B2)>=1984,"Millennial",
IF(YEAR(B2)>=1965,"Gen X",
IF(YEAR(B2)>=1946,"Baby Boomers",
IF(YEAR(B2)>=1927,"Traditionalists","-"))))

 

[zinah]

Thank you so much Asala!