age

[ck]

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

 

[Amish]

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

 

[Glenn]

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

 

[Amish]

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.