|
|
#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... 
|
|
|
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 7 32bit 
Office 2010 32bit
Threaded Mode