Getting Age from Date of Birth Formula

The UK's most regular instructor-led training courses.
Training information: excel training · Excel training london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

James has attended:
Excel Intermediate course

by - delegate James [4 posts] (2008 Mar 19 Wed, 11:21) Reply

Sorry I know I asked this question before but I can not find forum post

I know you can get the age from data as there is a forumla to use....can anyone let me know what it is

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Getting Age from Date of Birth Formula

by - delegate Paul gold contributer [121 posts] (2008 Mar 25 Tue, 11:44) Reply

I'm sure you can go about it in a long winded way, but I am not aware of a specific formula to do this. Perhaps I'm wrong.

Anyway, I would do something like =today()-A1 in a cell (let's say, cell B1 for demonstrative purposes) Make sure that this cell is formatted as a number, with no decimal places, then in cell C1, you can do something like this =ROUND(B1/365,0)

This will give you the age of the person/thing in years.

For instance, cell A1 contains 04/10/1984

in cell B1, type =today()-A1. This will return 8573 (the amount of days since 4th October 1984

in cell C1 type =ROUND(B1/365,0) this will give the result of 23.

RE: Getting Age from Date of Birth Formula

by - trainer Rich platinum contributer [744 posts] (2008 Mar 26 Wed, 17:26) Reply

Hi James,

Your original forum post is here:
http://www.microsofttraining.net/post-10350-getting-age-date-birth.html#10350

To see all your posts, choose 'Your posts/answers' from the top right of any forum page (when you are logged in).

Regards, Rich

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Reporting and Analysis with Excel
· Advanced Excel Training - takes you to the next level
· Microsoft Office and the Small Business: Part 1 Excel
· Crazy Things People Have Done With Excel

Please browse our web site to find out more about
excel training and other Microsoft training courses.