Dependent cell data validation

[SoulSister]

Hi, I have a visit schedule set up as a table. Visits are scheduled by quarter. I want to ensure, via data validation, that if cell C2 states 1 (ie Qtr1), that the visit date in D2 can only be between 01/04/15 to 30/06/15 (the dates in the quarter), if it's 2 then D2 can only be between 01/07/15 to 30/09/15 and so on for the other quarters. We currently have separate sheets in a single workbook and I need to bring them all onto one sheet. Hence the problem. Thanks in anticipation.