+ Reply to Thread
Results 1 to 7 of 7

Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed date.

  1. 12-03-2012, 05:22 PM #1
    sharpmel
    sharpmel is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Question Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed date.

    I have a tracking log for eligible participants. Given the child's date of birth and their clinic visit, I need to calculate if they are 17.99 years of age or younger at the time of the clinic visit. The date this is calculated from will constantly change (TODAY).
    Last edited by sharpmel; 12-03-2012 at 05:42 PM.
    Reply With QuoteRegister To Reply
  2. 12-03-2012, 05:23 PM #2
    djapigo
    djapigo is offline
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    Hi sharpmel,

    Try this... =IF(DATEDIF(child's DOB,TODAY(),"y")<18,"under 18", "18 and above")

    re-post... sorry forgot the DATEDIF function
    Last edited by djapigo; 12-03-2012 at 05:28 PM.
    Reply With QuoteRegister To Reply
  3. 12-03-2012, 05:29 PM #3
    sharpmel
    sharpmel is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    They all come up as 18 and above given =IF(TODAY()-E10<18,"under 18", "18 and above")
    E# = Child's DOB formatted: ##/##/##
    Reply With QuoteRegister To Reply
  4. 12-03-2012, 05:30 PM #4
    djapigo
    djapigo is offline
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    Sorry, sharpmel... try my re-posted formula... forgot the DATEDIF function...
    Reply With QuoteRegister To Reply
  5. 12-03-2012, 05:30 PM #5
    sharpmel
    sharpmel is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    They all come up as 18 and above given =IF(TODAY()-E10<18,"under 18", "18 and above")
    E# = Child's DOB formatted: ##/##/##
    Reply With QuoteRegister To Reply
  6. 12-03-2012, 05:40 PM #6
    djapigo
    djapigo is offline
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    Try this instead...

    =IF(DATEDIF(child's DOB,TODAY(),"y")<18,"under 18", "18 and above")
    Reply With QuoteRegister To Reply
  7. 12-03-2012, 05:41 PM #7
    sharpmel
    sharpmel is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Exclusion Criteria, Given Child DOB & Date of Visit. Child must be <18. Not a fixed da

    Thank you it worked!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1