formula for age at future date
 

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.

MEJ try this.

A1 is DOB. Type in B1 Today()

Type this formula in C1 =YEAR(B1)-YEAR(A1)

Type this in D1 =IF(C159,"Y","N")

This will give you a N for anyone under 60 and a Y for older then 60.

Hope this helps,

Paul



"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.

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.

See another response to your post in .newusers.

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.

--

Dave Peterson