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
Bookmarks