Thanks:  0
Likes:  0

# Thread: What is a formula/function to calculate age?

1. 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 ]

2. 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"

3. > 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 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•