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

date of birth age formula 8
How do I calculate a person's age given their birthdate and using. 1
calculate age from today's date (changes daily) and birthdate 4
Age 5
Calculate age 3
How do I calculate a person's age from date of birth and a date 2
Calculating Age NOT as of today but as of a date in the future or 3
Calculate age with an end date 3

Top