I need to be able to determine full retirement age, based on Year of Birth,
from the Social Security tables - I've actually figured out how to get and
accurate YY MM (in custom formatting), by subtracting date of birth from date
of retirement. -

But when I try to use the Year of Birth, by formatting the DOB into YYYY, I
cannot use that figure in other calculations, because it has been converted
to the Excel serial number.

Any thoughts?

=Year(A1) will give you the year of the date in A1

"Dan Cotts" wrote:

I need to be able to determine full retirement age, based on Year of Birth,
from the Social Security tables - I've actually figured out how to get and
accurate YY MM (in custom formatting), by subtracting date of birth from date
of retirement. -

But when I try to use the Year of Birth, by formatting the DOB into YYYY, I
cannot use that figure in other calculations, because it has been converted
to the Excel serial number.

Any thoughts?

You can get the year with the formula =year(A1) assuming the date of birth is
in cell a1.

If you have a date in A2, and you want to convert that to a year, the
formula is =YEAR(A2). format the result as number or general, and not as a
date.
--
David Biddulph

"Dan Cotts" wrote in message
...
I need to be able to determine full retirement age, based on Year of Birth,
from the Social Security tables - I've actually figured out how to get and
accurate YY MM (in custom formatting), by subtracting date of birth from
date
of retirement. -

But when I try to use the Year of Birth, by formatting the DOB into YYYY,
I
cannot use that figure in other calculations, because it has been
converted
to the Excel serial number.

Any thoughts?

thanks!! you all RULE!!

"TomPl" wrote:

You can get the year with the formula =year(A1) assuming the date of birth is
in cell a1.

"David Biddulph" wrote:

If you have a date in A2, and you want to convert that to a year, the
formula is =YEAR(A2). format the result as number or general, and not as a
date.
--
David Biddulph

"Dan Cotts" wrote in message
...
I need to be able to determine full retirement age, based on Year of Birth,
from the Social Security tables - I've actually figured out how to get and
accurate YY MM (in custom formatting), by subtracting date of birth from
date
of retirement. -

But when I try to use the Year of Birth, by formatting the DOB into YYYY,
I
cannot use that figure in other calculations, because it has been
converted
to the Excel serial number.

Any thoughts?

And your question was ...?
--
David Biddulph

"margoalicia" wrote in message
...


"David Biddulph" wrote:

If you have a date in A2, and you want to convert that to a year, the
formula is =YEAR(A2). format the result as number or general, and not as
a
date.
--
David Biddulph

"Dan Cotts" wrote in message
...
I need to be able to determine full retirement age, based on Year of
Birth,
from the Social Security tables - I've actually figured out how to get
and
accurate YY MM (in custom formatting), by subtracting date of birth
from
date
of retirement. -

But when I try to use the Year of Birth, by formatting the DOB into
YYYY,
I
cannot use that figure in other calculations, because it has been
converted
to the Excel serial number.

Any thoughts?