How do I calculate the date an employee will reach a specific age?

B

Bob Phillips

If you just want to add years, use

=DATE(YEAR(B1)+A1,MONTH(B1),DAY(B1))

where A1 holds the number of years, B1, the DoB.

If you want years, months and days, put each in A1,A2,A3, and use

=DATE(YEAR(B1)+A1,MONTH(B1)+A2,DAY(B1)+A3)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top