Thread: age
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default 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