Using Year of Birth, from DOB, in later calculations

[Dan Cotts]

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?

 

[TomPl]

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

 

[Sheeloo]

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

 

[Dan Cotts]

thanks!! you all RULE!!

 

[margoalicia]

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]

And your question was ...?[/QUOTE]