Calculate a date based on birthdate and future age

A

AMcShea

What formula would I use if I want to calculate a future date for when a
person will be a certain age, in this case it would be 22 years and 0 months.
Using 2007 version of excel.

Thanks
 
D

David Biddulph

If the date of birth is in A1,
=DATE(YEAR(A1)+22,MONTH(A1)+0,DAY(A1))
Adjust formula to suit. [Obviously you wouldn't bother with +0 if it was 0,
but that's where your number of months would go. You'd probably want to put
your 22 and 0 into separate cells & refer to those from your formula.]
 
J

Joel

A1 = 1/1/1990 The persons birthday then
A2 = 32 Future birthday at age 32

=Date(Year(A1)+A2,Month(A1),Day(A1))
 
G

Gary''s Student

If the birthday is in cell A1:

=DATE(YEAR(A1)+22,MONTH(A1)+0,DAY(A1))

will display the date that the person will be 22 years, 0 months old.
 
A

AMcShea

Thanks!
--
AKM


Gary''s Student said:
If the birthday is in cell A1:

=DATE(YEAR(A1)+22,MONTH(A1)+0,DAY(A1))

will display the date that the person will be 22 years, 0 months old.
Click to expand...
 

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

How to use/create code in MS Word to calculate age? 0
Date diffrence in days, weeks and months. 1
date of birth age formula 8
Age 5
Calculate horses age as at 1 August 6
Calculation based on year of entry 1
How do I calculate a person's age given their birthdate and using. 2
Calculating Age NOT as of today but as of a date in the future or 3

Top