age
Please give formula for age from Date of Birth i.e.
what is the age of: 14-Dec-54 12-Σεπ-57 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com