Formula to create generations based on birthday [Closed]

Report
-
TrowaD
Posts
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
-
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!!!

1 reply

Posts
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
389
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
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
389
That sounds like you used the = in front of a IF following the first IF. Could you post your formula?