Help!! How do I calculate age in an Excel spreadsheet

  • Thread starter Thread starter acarbonara
  • Start date Start date
A

acarbonara

I'm trying to calculate age using the date of birth of our
customers minus todays date but am coming up with another
date rather than their age. Is there a way of doing this?
 
Acarbonara,

It might be that when excel works with dates in calc's it
usually assumes the output should be a date, try
formatting the cell as General (Format -> Cells and under
the Number tab choose General) or Number.

If that doesn't work. Say A1 holds the birthdate
=DATEDIF(A1,TODAY(),"Y")
for more info on this function look here
http://www.cpearson.com/excel/datedif.htm
it's not in the help (except for 2000)

If it shows up as a date format it as general.

Dan E
 
Hi Chip!!!

Thanks so much, that was a wonderfully easy explanation
and it worked!! Thank you, sincerely, I'll be using this
site again definitely.

Angela
 
Thanks very much for your help!

Angela
-----Original Message-----
Acarbonara,

It might be that when excel works with dates in calc's it
usually assumes the output should be a date, try
formatting the cell as General (Format -> Cells and under
the Number tab choose General) or Number.

If that doesn't work. Say A1 holds the birthdate
=DATEDIF(A1,TODAY(),"Y")
for more info on this function look here
http://www.cpearson.com/excel/datedif.htm
it's not in the help (except for 2000)

If it shows up as a date format it as general.

Dan E

this?


.
Click to expand...
 
Back
Top