B
buzz
I am developing an Excel spread sheet that has date sets, not
necessarily entered in sequential order. I want an ERROR CHECK if a
date set entered violates a previously entered date set.
What I was looking for is a set of dates 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 fist and should be invalid, setting
off an alarm or not allowing it to be entered. I was thinking about
making the date entry idiot proof so that one could not enter date
sets within or covering dates sets previously entered. This one really
throws me, please help.
necessarily entered in sequential order. I want an ERROR CHECK if a
date set entered violates a previously entered date set.
What I was looking for is a set of dates 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 fist and should be invalid, setting
off an alarm or not allowing it to be entered. I was thinking about
making the date entry idiot proof so that one could not enter date
sets within or covering dates sets previously entered. This one really
throws me, please help.