dates into ages

's Computer Specifications

Column D is date received.
Column E is DOB.
What formula do I use to calculate the date of birth to land in column F?

's Computer Specifications

=DATEDIF(DOB,Received,"y")

will give you the year

http://www.cpearson.com/excel/datedif.htm

descriptions

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"Caz" <(E-Mail Removed)> wrote in message
news:FB89965A-41C0-4DFB-93B8-(E-Mail Removed)...
> Column D is date received.
> Column E is DOB.
> What formula do I use to calculate the date of birth to land in column F?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: calculating ages from dates before 1900	Rick Rothstein	Microsoft Excel Programming	0	24th Aug 2009 07:31 PM
Averaging a list of dates / ages	Human Resources	Microsoft Excel Misc	1	30th Jul 2009 05:27 PM
Dates/ Ages	Brian	Microsoft Excel Worksheet Functions	7	3rd Aug 2005 10:25 AM
dates and ages	mp	Microsoft Excel Misc	3	22nd Jun 2004 05:03 PM
Dates of Birth and ages	=?Utf-8?B?UGF1bGx5IEM=?=	Microsoft Excel Misc	3	28th Jan 2004 10:31 AM