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

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

 

[Chip Pearson]

You can use the DATEDIF function to do this. See
www.cpearson.com/excel/datedif.htm for more details.

 

[Dan E]

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

 

[acarbonara]

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

 

[acarbonara]

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?


.