I'm trying to use Data Validation to have a warning pop up to the user that the date they entered is not within the current week and am not having any luck. I've been attempting to use the "Custom" option within the validation function but it's failing to work. I just want this to be a warning that alerts the user of the situation but doesn't prevent them from continuing with the date if it's correct. In the attached example, the last date entered (cell C9) should show a warning based on comparing that week number (cell D9) to the first week number entered (cell D5), but allow the user to either continue using that date or go back and correct it if it's simply a data entry error. Thanks in advance for any assistance!Sample Date Validation.xlsx
Bookmarks