Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Data Validation

Posted on 2014-09-18
4
93 Views
Last Modified: 2014-09-18
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
Comment
Question by:pdvsa
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40330420
It works for me. Maybe if you post your spreadsheet, we can take a look...
0
 

Author Comment

by:pdvsa
ID: 40330455
ok I have attached...
EE.xlsx
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40330462
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
 

Author Closing Comment

by:pdvsa
ID: 40330501
perfect.  thank you
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question