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.]
--
David Biddulph

"AMcShea" wrote in message
...
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