Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation Based on a Date
Is this possible. Can I place a validation on an entire column to allow or
prevent data entry of whole numbers if I set the validation to accept a change only like so. for January - column E, validation would be to stop entry of info if =now() is greater than 01/01/2005? No macros please , because it's over 200 workbooks that are emailed out and these guys would disable the macros. |
#2
|
|||
|
|||
Would this do what you want?
Datavalidationcustom Formula: =TODAY()<DATEVALUE("1/1/2005") "JavyD" wrote in message ... Is this possible. Can I place a validation on an entire column to allow or prevent data entry of whole numbers if I set the validation to accept a change only like so. for January - column E, validation would be to stop entry of info if =now() is greater than 01/01/2005? No macros please , because it's over 200 workbooks that are emailed out and these guys would disable the macros. |
#3
|
|||
|
|||
oops, use <= rather than < .. to allow entry up through 1/1/2005..
"Dave R." wrote in message ... Would this do what you want? Datavalidationcustom Formula: =TODAY()<DATEVALUE("1/1/2005") "JavyD" wrote in message ... Is this possible. Can I place a validation on an entire column to allow or prevent data entry of whole numbers if I set the validation to accept a change only like so. for January - column E, validation would be to stop entry of info if =now() is greater than 01/01/2005? No macros please , because it's over 200 workbooks that are emailed out and these guys would disable the macros. |
#4
|
|||
|
|||
Dave youre a wiz, and here I'm trying to create vba for this, t hanks a
million. Now I just have to figure out a old trick that I had. To copy these validations to over 200 workbooks in a folder "Dave R." wrote: oops, use <= rather than < .. to allow entry up through 1/1/2005.. "Dave R." wrote in message ... Would this do what you want? Datavalidationcustom Formula: =TODAY()<DATEVALUE("1/1/2005") "JavyD" wrote in message ... Is this possible. Can I place a validation on an entire column to allow or prevent data entry of whole numbers if I set the validation to accept a change only like so. for January - column E, validation would be to stop entry of info if =now() is greater than 01/01/2005? No macros please , because it's over 200 workbooks that are emailed out and these guys would disable the macros. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |