| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
age
Please give formula for age from Date of Birth i.e.
what is the age of: 14-Dec-54 12-Σεπ-57 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
age
if age is in cell a1...
=(NOW()-A1)/365.25 -- Hope this helps. Thanks in advance for your feedback. Gary Brown "pavlos" wrote: Please give formula for age from Date of Birth i.e. what is the age of: 14-Dec-54 12-Σεπ-57 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
age
=DATEDIF(A1,TODAY(),"y")
"pavlos" wrote: Please give formula for age from Date of Birth i.e. what is the age of: 14-Dec-54 12-Σεπ-57 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
age
With 14-Dec-54 in A1 use:
=DATEDIF(A1,TODAY(),"y") -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pavlos" wrote in message ... Please give formula for age from Date of Birth i.e. what is the age of: 14-Dec-54 12-???-57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
