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 January 16, 2023 - 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!!!

Formula to create generations based on birthday
Create skype account with gmail - Guide
Create instagram account on pc - Guide
Request birthday change facebook locked account - Guide
Create snapchat account - Guide
Excel macro to create new sheet based on value in cells - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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 January 16, 2023 549
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

How do I change a base location on Instagram?

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

How to unlock fb account with date of birth i need link

Similar discussions

Subscribe To Our Newsletter!