I solved it already. Thanks for your help. I used Datedif function before
but somehow it didn't apply to this scenario. Instead I used the following:
=IF(I2=55,"Age 55",IF(I255,"over 55",IF(I2<55,"under 55")))
Hey, looks like my Excel is improving thanks to the community board. Thanks
again.

"Bob Phillips" wrote:

You can easily calculate the age with

=DATEDIF(A1,TODAY(),"y")

what do you want to do then?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Containsmiles" wrote in message
...
Hi, I'm working on a project and I was wondering if anyone can help me. I
need to know the formula that I can use to input the age of each
individuals,
those who are "under 55", "age 55", and "over 55". I tried to input the
formula for all three but it said that I enter too many arguments. Any
help
would be appreciated.