+ 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.

Hybrid View

  1. #1
    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 to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1