ERROR check if a date set entered violates a previously entered date set

B

buzz

I am devloping an Excel program that has a list of date sets, not
necessarily in sequencial order. What I want is an ERROR CHECK if a
date set violates any date set previously entered.
What I was looking for was that a date set could not be typed in as
follows:
1/10/04 to 4/20/04
2/10/04 to 3/20/04
The second date set falls within the first set and should be invalid
setting off a message or an alert of an invalid entry. I am
interested in making it idiot proof so that one could not enter date
sets within or covering dates sets already entered. This one really
throws me, Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ERROR check if a date set entered violates a previous date set 1
ERROR check if a date set entered violates a previously entered date set 1
Sumproduct with variation 1
Entering dates QUICKLY 4
Excel check if dates are under a range of week 4
Error Check Dates 1
Compare a value to a list of values 1
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0

Top