formula telling me if person is 19 or older today

[Guest]

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.

 

[T. Valko]

Try this:

=DATEDIF(dob,TODAY(),"y")

Biff

 

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

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

 

[Guest]

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.

 

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

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

Rick

 

[Guest]

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