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

In cell e1 allow custom>in formula
=E1=TODAY()+1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Seanie" <(E-Mail Removed)> wrote in message
news:c2bbf4d8-e450-4f67-a9dd-(E-Mail Removed)...
> 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

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
>

Thanks for the catch Shane
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Shane Devenshire" <(E-Mail Removed)> wrote in
message news:B6C411D2-190B-4725-BDDE-(E-Mail Removed)...
> 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
>>