formula telling me if person is 19 or older today

K

kelley

I need a formula to tell me if a person turned 19 today or is older than 19
based on dob. Excel 2000. thank you.
 
R

Rick Rothstein \(MVP - VB\)

I need a formula to tell me if a person turned 19 today or is
older than 19 based on dob. Excel 2000. thank you.
Click to expand...

Is this what you were after?

=IF(A1=DATE(YEAR(NOW())-19,MONTH(NOW()),DAY(NOW())),"Born
today",IF(A1<DATE(YEAR(NOW())-19,MONTH(NOW()),DAY(NOW())),"Older than
19","Too young"))

where I have assumed the date of birth is in A1.

Rick
 
K

kelley

Congratulations, you have come closer than anyone. Thank you. For some
reason, the first few months of the birthday year and a few days after the
19th birthday, compute incorrectly. This is the closest I have come, though.
 
R

Rick Rothstein \(MVP - VB\)

Congratulations, you have come closer than anyone. Thank you. For some
reason, the first few months of the birthday year and a few days after the
19th birthday, compute incorrectly. This is the closest I have come,
though.
Click to expand...

Can you post a couple of examples where this is the case so that I can track
down where the problem is?

Rick
 
B

bj

verify the format of the date in A1 is as you expect it to be
=day(A1)
=Month(A1)
I have had data I though was MM/DD/YY which was really DD/MM/YY
 
Top