- Oct 1, 2004
I have been assigned a task to help with scheduling, and need help on a formula. Below is a 2 lists of dates that I must be able to verify with a true or false answer for the following condition. If any of the Dates in Date List 1 match or are within the same calendar week as any of the dates in Date List 2 I need a "true" response. If the dates in both lists have no matches and none fall within the same calendar week I then need a false response. I cannot seem to figure out how to do it. Any help would be very appreciated!! Thanks!