Calculating age at date

jamierbooth · #1 02-21-2011, 05:41 AM

I need a formula that will tell me what age someone was on a given date.
I have date of birth in column 1, date of referral in column 2, age on date of referral in column 3.

Thanks world!!

Colin Legg · #2 02-21-2011, 07:45 AM

Hi

The exact formula will depend on how you want the age reported.

In years? Like this:

Code:

=DATEDIF(A2,B2,"y")&" years"

In years and months? Like this:

Code:

=DATEDIF(A2,B2,"y")&" years " & DATEDIF(A2,B2,"ym") &" months"

etc...

jamierbooth · #3 02-22-2011, 03:35 AM

Excellent. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Last edit date'	markg2	Word	3	12-26-2010 04:27 PM
Need a date formula	MPAVLAS	Excel	3	08-12-2010 10:04 PM
Calculating Form Fields in Microsoft Word	wubba80	Word	1	06-25-2010 12:42 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM