age
 

I need help calculating age ranges. Currently I have a column of ages in
years and months. I need an additional column that shows if the age is from
0-3 months, 3-6 months, or 6months - 1year old. Any help would be appreciated

age
 

How are your ages stored? If you're storing a value, then this would
be simple with something like a vlookup, but if you're typing in
values and text into the same cell you might have a more difficult
time because you would have to parse out the values.

I have an old example of this where I subtract a date from =now() and
then use the following formula:
=QUOTIENT(D4,365.25)&" years, "&INT(MOD(D4,30))&" months"
and it displays:
17 years, 11 months

There are probably better formulas out there, but this is one I had :)


On Feb 25, 10:30*am, ck wrote:
I need help calculating age ranges. *Currently I have a column of ages in
years and months. *I need an additional column that shows if the age is from
0-3 months, 3-6 months, or 6months - 1year old. *Any help would be appreciated

age
 

ck wrote:
I need help calculating age ranges. Currently I have a column of ages in
years and months. I need an additional column that shows if the age is from
0-3 months, 3-6 months, or 6months - 1year old. Any help would be appreciated


http://www.cpearson.com/excel/datedif.aspx

age
 

Sorry, I meant to add that you should probably do the vlookup off the
value of the subtraction, not my goofy combo text/value cell.

On Feb 25, 11:06*am, Amish wrote:
How are your ages stored? If you're storing a value, then this would
be simple with something like a vlookup, but if you're typing in
values and text into the same cell you might have a more difficult
time because you would have to parse out the values.

I have an old example of this where I subtract a date from =now() and
then use the following formula:
=QUOTIENT(D4,365.25)&" years, "&INT(MOD(D4,30))&" months"
and it displays:
17 years, 11 months

There are probably better formulas out there, but this is one I had :)

On Feb 25, 10:30*am, ck wrote:

I need help calculating age ranges. *Currently I have a column of ages in
years and months. *I need an additional column that shows if the age is from
0-3 months, 3-6 months, or 6months - 1year old. *Any help would be appreciated