Using Year of Birth, from DOB, in later calculations
 

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?

Using Year of Birth, from DOB, in later calculations
 

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

Using Year of Birth, from DOB, in later calculations
 

=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?

Using Year of Birth, from DOB, in later calculations
 

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?

Using Year of Birth, from DOB, in later calculations
 

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.

Using Year of Birth, from DOB, in later calculations
 

"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?

Using Year of Birth, from DOB, in later calculations
 

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?