If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ERROR check if a date set entered violates a previously entered date set
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. |
#2
|
|||
|
|||
ERROR check if a date set entered violates a previously entered date set
Are the dates in separate celss or is the from to date in
one cell? If the latter then it is text. If the former then you can check the date against other entries. Even set up the worksheet with an entry macro that chwecks the data. Mark -----Original Message----- 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. . |
Thread Tools | |
Display Modes | |
|
|