View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default formula to calculate age using birth date and current date

=DATEDIF(DOB,TODAY(),"Y")

--
Regards,

Peo Sjoblom

(No private emails please)


"lalah" wrote in message
...
what formula would you use to calculate current age given the birth date
and
current date in the worksheet