formula for age at future date

M

MEJ

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

pjscott

MEJ try this.

A1 is DOB. Type in B1 Today()

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

Type this in D1 =IF(C1>59,"Y","N")

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

Hope this helps,

Paul
 
D

Dave Peterson

See another response to your post in .newusers.
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.
Click to expand...
 
Top