It would be easier if you had two date columns, one (col a) mm/dd and the
other (col b) yyyy. In a third column (col c), enter =2010-b2. In the
fourth column (col d), enter =IF(C164,"YES",""). Drag the formulas down to
the end of the data. You may have to format the C column as a number (no
decimals).

Hope this helps,
Carole O

"MEJ" wrote:

I'm a new user and need help. I have a column with dates of birth (xx/xx/xx)
and want to know the age (in years only) that each person will be by the end
of 2010. Then I want to indicate "yes" if they will be 65 or older by that
time. Thanks!
--
MEJ