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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prob an easy one: How do i copy a formula EXACTLY as it is 9
Need Formula for Calculating Accrued Vacation Time 2
Number of years, months, days between two dates. 34
How do I calculate a person's age on a specific date? (huge roster 2
My discovery on adding months and days to a date! 8
date function 10
how to count my paydays before the due-date of a bill? 11
Using date function in an if statement 2

Top