Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Age Function (2003)

    hi can you help me with the function for ages based on the date of birth please see attachment
    thanks
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Age Function (2003)

    =DATEDIF(A3,TODAY(),"y")

    Copy/autofill down the column

    Steve

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Age Function (2003)

    Hi Kitty

    Let's make it more fun, with Years, Months and Days <img src=/S/grin.gif border=0 alt=grin width=15 height=15>:

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

    and copy down
    Jerry

  4. #4
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Age Function (2003)

    well done jez legend answer, well save that for another moment in time. x

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •