View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default how do I work out age in years, months, days in excel

With DOB in cell A1

=DATEDIF(A1,TODAY(),"y")&" years "&
DATEDIF(A1,TODAY(),"ym")&" months "&
DATEDIF(A1,TODAY(),"md")&" days"

If this post helps click Yes
---------------
Jacob Skaria


"Tru Colours" wrote:

I'd like to be able to work out ages in years, months and days - in excel -
but I just can't figure it out.
I've managed to do years and points (tenths) of a year but would like to be
much more accurate.
Can anyone help please?
Thanks in advance.