Formula to create generations based on birthday [Closed]

-
I need a formula in excel that will indicate generations based off of a birthdate.

Generations:
Traditionalists (Prior to 1943)
Baby Boomers (1943-1960)
Generation X (1961-1981)
Millennials (1982-2000)

Thanks!!!
See more 

1 reply

Posts
2566
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 19, 2019
370
0
Thank you
Hi Kristy,

Give the following formula a try where the date of birth is in A1:
=IF(YEAR(A1)<1943,"Traditionalists",IF(AND(YEAR(A1)>=1943,YEAR(A1)<=1960),"Baby Boomers",IF(AND(YEAR(A1)>=1961,YEAR(A1)<=1981),"Generation X",IF(AND(YEAR(A1)>=1982,YEAR(A1)<=2000),"Millennials","Not defined"))))

Best regards,
Trowa
sereana26
Posts
1
Registration date
Wednesday June 19, 2019
Status
Member
Last seen
June 19, 2019
-
I am trying to use a similar formula, but I keep getting an error saying that excel is reading the = as starting a new formula and to insert an apostrophe before the =. I've tried doing this and I'm still getting the error. Any thoughts?
TrowaD
Posts
2566
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 19, 2019
370 -
That sounds like you used the = in front of a IF following the first IF. Could you post your formula?