> I've got a worksheet that includes dates of birth for a list of customers. How can I calculate an age for each customer based on their date of birth?
Use one of:
=DATEDIF(A1,TODAY(),"y")
=YEARFRAC(TODAY(),A1)
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days"
where A1 houses a birth date.
Did you know that you could have found the answer by using the 'Search' facilty on this board?
This message was edited by Aladin Akyurek on 2002-03-03 11:26