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

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

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

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