Formula to create generations based on birthday

Closed
KristyAnn8000 - Updated on Jul 3, 2018 at 01:52 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jun 20, 2019 at 10:59 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 3, 2018 at 11:54 AM
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
2
sereana26 Posts 1 Registration date Wednesday June 19, 2019 Status Member Last seen June 19, 2019
Jun 19, 2019 at 03:21 PM
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?
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 20, 2019 at 10:59 AM
That sounds like you used the = in front of a IF following the first IF. Could you post your formula?
0