I have a spreadsheet that will contain 3 dates. The first date that can be entered will be a date of birth, a few columns later there will be a date sample was taken followed by date the sample was analyzed. I would like to ensure that the DOB meets certain criteria. DOB must not make someone older than 90 years old, DOB should not be for someone who is less than 60 days old (no newborns). For the date sample was taken, oftentimes the end user will accidentally put in the dob instead of the date of the test/sample, so I want it to always be greater than (ideally 60 days more than) the birth date, but not a future date. For the date analyzed, it cannot be before the date the sample was taken, cannot be before the person was born, cannot be in the future, and I would like it to flag (but allow the entry) if the date analyzed is greater than 14 days from the date the sample was taken?

examples: Assuming Today is 01/20/2017, then DOB cannot be after 11/20/2016 (or whatever 60 days is), the date of the sample can be today's date (1/20/2017, and the date analyzed can also be today's date (date analyzed may equal date of sample, but date analyzed cannot be before date sampled) If date sampled = 12/20/2016, and user enters 01/20/2017 for date analyzed, there should be an alert that would ask if they were sure they waited 30 days (doesn't have to specify the difference between the dates, it can just say 'did you really not analyze this within 2 weeks?) to analyze a sample? (but, if they really did screw up like this, then it allows the date to be entered). What would the data validation formulas look like for these instances??