age calculation

SuzyQ · May 4th, 2002, 05:52 PM

Cn someone please tell me how to subtract a properly formatted birthdate from 07/01/2002 to arrive at the person's actual age ? I would be very grateful. Thanks

GeorgeB · May 4th, 2002, 05:59 PM

Just subtract one from the other.

sen_edp · May 4th, 2002, 06:00 PM

hello

take a look at this

http://www.mrexcel.com/board/viewtop...c=7148&forum=2

Dave Patton · May 4th, 2002, 06:16 PM

You can use Datedif. Datedif is in nearly all versions of Excel but it was only documented in Excel2000.

With Date of Birth as a valid date and that cell named DOB use the formula below. Use a second date such as TODAY or the date that you cited (07/01/2002); note you can use cell references. If you want all the information in one cell with text, consider

=DATEDIF(DOB,TODAY(),"Y")&" years, "&DATEDIF(DOB,TODAY(),"ym")& " months, and "&DATEDIF(DOB,TODAY(),"md") &" days"

You can extract the sub parts and have each part in a separate cell.

Note: There are some anomalies with the day calculations.

[ This Message was edited by: Dave Patton on 2002-05-04 17:18 ]

May 4th, 2002, 05:59 PM	#2
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Just subtract one from the other. __________________ George Learn to listen. Opportunity sometimes knocks very softly.

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

May 4th, 2002, 05:52 PM	#1
SuzyQ New Member Join Date: May 2002 Posts: 1	Cn someone please tell me how to subtract a properly formatted birthdate from 07/01/2002 to arrive at the person's actual age ? I would be very grateful. Thanks

May 4th, 2002, 06:00 PM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello take a look at this http://www.mrexcel.com/board/viewtop...c=7148&forum=2

May 4th, 2002, 06:16 PM	#4
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	You can use Datedif. Datedif is in nearly all versions of Excel but it was only documented in Excel2000. With Date of Birth as a valid date and that cell named DOB use the formula below. Use a second date such as TODAY or the date that you cited (07/01/2002); note you can use cell references. If you want all the information in one cell with text, consider =DATEDIF(DOB,TODAY(),"Y")&" years, "&DATEDIF(DOB,TODAY(),"ym")& " months, and "&DATEDIF(DOB,TODAY(),"md") &" days" You can extract the sub parts and have each part in a separate cell. Note: There are some anomalies with the day calculations. [ This Message was edited by: Dave Patton on 2002-05-04 17:18 ]