Calculate Age Generation Using Excel Function

Question

Hi,

Looking for a function in Excel that calculates birthdate cell and provides the relevant age generation type, like Generation Z, Baby Boomer, ...

Any ideas?

Answer 1

You can use the same logic I presented in the example, just changing the condition to IF(AND(YEAR()))

Here I leave an example of a condition checking the year in the formula

=IF(AND(YEAR(A2)>1965;YEAR(A2)<1981);"Gen X";"FALSE")

Answer 2

Age Calc:

=INT((TODAY()-A2)/365,5)

Class:

=IF(AND(B2>=0;B2<10);"Alpha";IF(AND(B2>9;B2<26);"Z Generation";IF(AND(B2>25;B2<41);"Y Generation";IF(AND(B2>40;B2<60);"X Generation";"Baby Boomer"))))

Download example:

https://we.tl/t-aW1KWmnFtt

Answer 3

Dear Mihokiller,

Thank you really for the useful solution.

Hence, isn't there any way to get the function compare if the birth year is within a specific range?

For example, if the birth year is between 1965 to 1981 then it should be Gen. X

What do you think?

Answer 4

Hi

My name is André. I am an independent consultant.

Basically what you need is a formula that calculates age. And another one, using IF, that defines based on age. I'll create an example and leave it here for you to download.

Answer here so I can continue helping you.

André.