Thanks!
--
AKM


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200824


"AMcShea" wrote:

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
--
AKM