Results 1 to 11 of 11

Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Question Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.

    I am calculating the age of a child based on their DOB. I currently have =INT((TODAY()-'Qualtrics Output'!N3)/365.25) but I do not believe this accounts for leap years (our study is over 5+ years) and it also occurred to me that this formula will continually update. Basically, I need the child's age based on the day that the information is entered into Excel. To make things even more complicated, I need to calculate the age in months ONLY IF the child is less than 2 years old.
    Last edited by sharpmel; 12-05-2012 at 03:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1