Thread: How do I convert a list of date of births into age in Excel?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
manjunath manjunath is offline
external usenet poster
  
Posts: 6
Default How do I convert a list of date of births into age in Excel?
Hi Frinda,

To be more precise use this formula you will get No of years,No of month,No
of days.

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

date should be in A1 cell


Regards,
Manjunath

"Frieda" wrote:

I am trying to convert a full list of date of births to be displayed as the
age. Is there a simple way to do this without subtracting each date from the
current date separately?
Thank you.
Reply With QuoteReply With Quote