What is a formula/function to calculate age?

[portsabum]

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?

_________________
This message was edited by portsabum on 2002-03-03 11:15

 

[gplhl]

On 2002-03-03 11:14, portsabum wrote:
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?

_________________
This message was edited by portsabum on 2002-03-03 11:15

If you had the birthday in A1 put =TODAY() in B1.
In C1 put =B1-A1

Format C1 using Custom:

yy" Years "mm" Months "dd"Days"

 

[Aladin Akyurek]

> 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