I have a worksheet that has 32 cells for inputing the date. I want an error message to show if someone duplicates a date. How can I use Data Validation to make this happen?
Suppose my date entry cells are R7, R67, R127 etc. Someone inputs 4/18/15 into cell R7, inputs 4/19/15 into R67 and 4/18/15 into R127. I would like to have an error message telling them that the date has already been input, and to please choose a different date.
Thanks in advance for any and all suggestions.
Suppose my date entry cells are R7, R67, R127 etc. Someone inputs 4/18/15 into cell R7, inputs 4/19/15 into R67 and 4/18/15 into R127. I would like to have an error message telling them that the date has already been input, and to please choose a different date.
Thanks in advance for any and all suggestions.