Formula to create generations based on birthday

Closed

KristyAnn8000 - Updated on Jul 3, 2018 at 01:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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!!!

Gen x dob
Create skype account with gmail - Guide
Create instagram account on pc - Guide
Number to words in excel formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Create snapchat account - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

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?

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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?

Similar discussions

Why can't I bridge connect?

help me to add particular cells

Hi Guys how to create an account for facebook with my company em

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!