Hi,

If you want to use the date in column C instead of the number in column B,
the following formula may do what you want:

=YEARFRAC(TODAY(),C1,1)

This will update daily and will display the results in years and fractional
parts.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"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