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 discharge could not be typed in as
follows:
1/10/04 to 4/20/04
2/10/04 to 3/20/04
The second date falls within the first 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 dates within or
covering dates already entered. This one really throws me, Please
help.
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 discharge could not be typed in as
follows:
1/10/04 to 4/20/04
2/10/04 to 3/20/04
The second date falls within the first 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 dates within or
covering dates already entered. This one really throws me, Please
help.