|
|
|
|
#1
02-21-2011, 05:41 AM
|
|||
|
|||
Calculating age at date
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!! 
|
|
#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" Code:
=DATEDIF(A2,B2,"y")&" years " & DATEDIF(A2,B2,"ym") &" months" etc...
|
|
#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 |
Windows XP 
Office XP
Hybrid Mode