Birthdate vs age

[val]

Does any one know a formula that will convert the
birthdate to an individual age so I don't have to figure
the age manually.

I can't find any information on this item -- assistance is
appreciated.

Thanks

 

[Dan E]

Val,

If you had the birthday in A1

=DATEDIF(A1,TODAY(),"Y")

Datedif isn't listed in the function wizard, but can be
found in the help menu.

Dan E

 

[J.E. McGimpsey]

Only in XL2000 (though I don't know about XL2003).

For all other XL versions, look here:

http://cpearson.com/excel/datedif.htm