What is a formula/function to calculate age?

portsabum · Mar 3rd, 2002, 12:14 PM

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 · Mar 3rd, 2002, 12:22 PM

Quote:

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 · Mar 3rd, 2002, 12:25 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 12:14 PM	#1
portsabum New Member Join Date: Mar 2002 Location: Duluth, Minnesota, USA Posts: 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 ]

Mar 3rd, 2002, 12:25 PM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	> 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 ]