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

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

Sorry for the typo
Use

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

"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

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