|
|
#2
06-01-2012, 02:37 AM
|
|||
|
|||
In A2 for example put a persons DOB i.e 13/08/1969 then in B2 enter
=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days" Copy down as needed. The result will show the difference from the current date to include the number of years, months and days. The best news is that you don't have to update the formula if you open the file at a later date; the age will automatically recalculate based on the current date. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| add values to dropdown selections and calculate | guyhs | Word | 7 | 10-24-2012 05:11 PM |
 How to calculate percentages???
|
fabthi | Excel | 3 | 04-13-2012 12:08 PM |
|
What formula should I use to calculate commission?
|
grs | Excel | 3 | 02-21-2011 02:17 AM |
| Can't calculate formulas | Cpat | Excel | 2 | 06-09-2010 02:07 PM |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Windows XP 
Office 2007
Threaded Mode