Hi,

Try this:

=YEAR(TODAY())-YEAR(A1)

asumed the age is in A2.

Thanks,
--
Farhad Hodjat


"Chub822" wrote:

I am trying to write a formula for a class where we have to take todays date
(using the today function) and subtract it from a set of dates to see if the
people are over 18 or not. Im having trouble with the TODAY function.

every time i try to use it the T turns in to a lower cass letter and it says
that the function is invalad. any sugestions!