| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Q
Would it be possible to have a Data Validation that will only allow
input of Today+1 or later. I don't require a strict 24hours of a difference, just the actual date must be Today+1 eg if I input today (21/2/09) I would have to input 22/2/09 at least |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Q
In cell e1 allow customin formula
=E1=TODAY()+1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Seanie" wrote in message ... Would it be possible to have a Data Validation that will only allow input of Today+1 or later. I don't require a strict 24hours of a difference, just the actual date must be Today+1 eg if I input today (21/2/09) I would have to input 22/2/09 at least |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Q
Hi,
"or later" - Select the range where you want the data validation, suppose A1:A10, choose Data, Validation, Custom and enter the formula =A1=TODAY()+1 -- If this helps, please click the Yes button Cheers, Shane Devenshire "Seanie" wrote: Would it be possible to have a Data Validation that will only allow input of Today+1 or later. I don't require a strict 24hours of a difference, just the actual date must be Today+1 eg if I input today (21/2/09) I would have to input 22/2/09 at least |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Q
Thanks for the catch Shane -- Don Guillett Microsoft MVP Excel SalesAid Software "Shane Devenshire" wrote in message ... Hi, "or later" - Select the range where you want the data validation, suppose A1:A10, choose Data, Validation, Custom and enter the formula =A1=TODAY()+1 -- If this helps, please click the Yes button Cheers, Shane Devenshire "Seanie" wrote: Would it be possible to have a Data Validation that will only allow input of Today+1 or later. I don't require a strict 24hours of a difference, just the actual date must be Today+1 eg if I input today (21/2/09) I would have to input 22/2/09 at least |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Hybrid Mode
