In two cells, D2 and D3, I have two dates. D2 will always be < D3. I have a userform check box called DOW.

If DOW is checked I need to see if between the dates in D2 and D3 if there is a Tuesday.

For example if
D2 = 12/10/14
D3 = 12/12/14

There is no Tuesday. In this event make H5 = N and if it is correct then make H15 = Y