Formula to create generations based on birthday [Closed]

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