Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

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:
Data Validation criteria
0
pdvsa
Asked:
pdvsa
  • 2
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
It works for me. Maybe if you post your spreadsheet, we can take a look...
0
 
pdvsaProject financeAuthor Commented:
ok I have attached...
EE.xlsx
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I think what you want is the other way wrong. Your dialog box should say:

Allow: Date
Data: greater than
Start date: =C2+30
0
 
pdvsaProject financeAuthor Commented:
perfect.  thank you
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now