dates

[[email protected]]

dob 22/07/1975
today 28 February 2006
term to age 60 _______
term to age 65 _______

Hi,
Assuming the above data, i am looking to have a cell at the point of
the underlined to calculate, based on the date of birth, how many years
there are until either 60 or 65. I have tried to convert the date of
birth to a number but I never seem to be able to get it to work.

Thanks

[Bob Phillips]

See http://www.cpearson.com/excel/datedif.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> dob 22/07/1975
> today 28 February 2006
> term to age 60 _______
> term to age 65 _______
>
> Hi,
> Assuming the above data, i am looking to have a cell at the point of
> the underlined to calculate, based on the date of birth, how many years
> there are until either 60 or 65. I have tried to convert the date of
> birth to a number but I never seem to be able to get it to work.
>
> Thanks
>

[Ardus Petus]

Here's an example worksheet with staging rows you can hide
http://cjoint.com/?cCkT5N4Dp7

HTH
--
AP

<[email protected]> a écrit dans le message de
news:[email protected]...
> dob 22/07/1975
> today 28 February 2006
> term to age 60 _______
> term to age 65 _______
>
> Hi,
> Assuming the above data, i am looking to have a cell at the point of
> the underlined to calculate, based on the date of birth, how many years
> there are until either 60 or 65. I have tried to convert the date of
> birth to a number but I never seem to be able to get it to work.
>
> Thanks
>

[[email protected]]

absolutely fabulous.

Works brilliantly.

Cheers