Share via

Calculate Age Generation Using Excel Function

Anonymous
2022-12-26T13:09:25+00:00

I am trying to calculate the age generation using the following excel function but somehow it gives me an error message.

=IF(YEAR(AE7)<1946;"Traditionals";IF(AND(YEAR(AE7)>=1946;YEAR(AE7)<=1964);"Baby Boomers";IF(AND(YEAR(AE7)>=1965;YEAR(AE7)<=1977);"Gen X";IF(AND(YEAR(AE7)>=1978;YEAR(AE7)<=1995);"Millennials";IF(AND(YEAR(AE7)>=1995;"Gen Z";"FALSE")))))

Being AE the column with the date of birth.

Can someone help me with this formula?

Thank you in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-12-26T15:07:15+00:00

Another Option:

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

riny 20,870 Reputation points Volunteer Moderator
2022-12-26T14:52:09+00:00

Not sure I follow. When you put the IF's in the correct order it should return the correct category. For instance, someone born in 1950 will not be <1946 but will be <=1964, so he/she will be a baby boomer. No need to set the lower boundary.

Actually, it would be easier to use a LOOKUP to avoid the nested IF statements.

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

riny 20,870 Reputation points Volunteer Moderator
2022-12-26T13:30:53+00:00

I believe this one will work:

=IF(YEAR(AE7)<1946;"Traditionals";IF(YEAR(AE7)<=1964;"Baby Boomers";IF(YEAR(AE7)<=1977;"Gen X";IF(YEAR(AE7)<=1995;"Millennials";IF(YEAR(AE7)>=1995;"Gen Z")))))

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2022-12-26T14:34:12+00:00

    I believe this one will work:

    =IF(YEAR(AE7)<1946;"Traditionals";IF(YEAR(AE7)<=1964;"Baby Boomers";IF(YEAR(AE7)<=1977;"Gen X";IF(YEAR(AE7)<=1995;"Millennials";IF(YEAR(AE7)>=1995;"Gen Z")))))

    Hi,

    Thanks for your help. However, it does not work 100% as it would be important to tag the generation age to a time interval, such as:

    Traditionals (<1946)

    Baby Boomers (1946-1964)

    Gen X (1965-1977)

    Millennials (1978-1995)

    Gen Z (>1995)

    Was this answer helpful?

    0 comments