Formula to create generations based on birthday [Closed]

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