Enter this in D1
=DATE(YEAR(A1)+51,MONTH(A1)+8,DAY(A1))

8 years and6 months fromage at 60 years is same as 51 years plus 6 months
from birth...

"oldLearner57" wrote:

hi community

how can i find the balance date in the future date format, below is an example

birthdate Age Target 60 years old balance date
(yy-mm) - 60yrs

01-May-1957 51.6 01-May-2017 ??

how can i do the 4th column where I wish to know what is the date be example
above is 8 years 6 months balance before reaching 60 years old

can anybody assist me on this??

10s community for the kind assistance given

:)
--
oldLearner57