balance date

[oldLearner57]

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

 

[Sheeloo]

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

 

[Sheeloo]

Sorry for the typo
Use

=DATE(YEAR(A1)+51,MONTH(A1)+6,DAY(A1))
with birthdate in A1

 

[Shane Devenshire]

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