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?