Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating dates in a cell
I have a worksheet in which a transaction date is entered into cells
in column A. I need to validate that date when it is entered to insure it is no earlier than Today() and no greater than Today()+30. The worksheet is perpetual so data validation at the cell level won't work. How can I validate the date at a macro level so that the cell value doesn't become invalid 31 days in the future? TIA BrianG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating dates in a cell
Why do you say data validation at the cell level won't work? The
following does for me. Allow: Date Data: between Start date: =TODAY() End date: =TODAY()+30 Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating dates in a cell
The worksheet is perpetual so I assumed that dates entered this month
would become invalid next month. Now that I think about it, the validation only occurs at the time of entry. Would this mean that cell level validation would only become a problem if someone went back to an old date and tried to edit it to a value that was outside the validation range? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating dates in a cell
Would this mean that cell level validation would only become a
problem if someone went back to an old date and tried to edit it to a value that was outside the validation range? Yes. Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct - validating codes & dates | Excel Worksheet Functions | |||
Validating certain cell | Excel Worksheet Functions | |||
Validating Dates Entered | Excel Discussion (Misc queries) | |||
Validating Dates | Excel Programming | |||
Event validating two ranges with dates | Excel Programming |