The criteria I have is: [Disbursement_Date] (its in cell C3) cant be within 30 days of a [Disbursement_Request] i(ts in cell C2).
I am using Data Validation for this.
I have the following so far:
Data: Less than
End Date = C2-30
I have also tried Greater than
For any date I enter in C3 I get the Data Validation message but I only need the message if the date entered is within 30 days of a [Disbursement_Request]
How can I do this? Not sure if I need a "between" i/o less than or greater than.
screen print of data validation: