See Chip Pearson's site at the link below for a thorough explanation of how
to calculate age

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

Duke

"MEJ" wrote:

A1 is date of birth in 01/15/30 format. Need to show how old each person
will be (years only) by end of 2010. Then need to indicate Y or N if they
will be 65 or older at that time.