For example, the Date of birth is 02/16/2009, but in order for the person to meet the criteria they had to have had an appointment between 45 days old and 2 years old. So an appointment on 02/17/2011 would not meet criteria just as an appointment on 03/15/2009 would not. An appointment even one day after turning 2 years old would not meet criteria. How do I create a formula in Excel that would give me results of “Meets” or “Does Not Meet” based on the appointment date in relation to birthdate? Like, if appointment date is 05/23/2009 then “Meets”, and if appointment date is 09/23/2011 then “Does Not Meet”.
I’ve created a formula that uses an “If” statement with a “Datedif” and a ”concatenate” function within it, but it doesn’t seem to work once appointments fall in 2011.
Bookmarks