Using Year of Birth, from DOB, in later calculations

D

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

TomPl

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

David Biddulph

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.
 
M

margoalicia

David Biddulph said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date of birth or blank cell? 3
Financial Time Value of Money calculations 5
Calculating age from date of birth and ignoring if blank 3
How do I calculate a person's age from date of birth and a date 4
date of birth age formula 8
using a year in a date 7
Excel - Calculate age from DOB in years, months days 7
How do you calculate age from just having a Date of Birth? 2

Top