pdvsa
asked on
Data Validation
Experts,
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.
thank you
screen print of data validation:
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.
thank you
screen print of data validation:
It works for me. Maybe if you post your spreadsheet, we can take a look...
ASKER
ok I have attached...
EE.xlsx
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect. thank you