Does Validation works for date ??

[Little Master]

Hi

Does data validation works for date ??
For example : A1 contains today's date in it & if some one tries to put
yesterday's date in B1 it will not allow(we can put tomorrow's date).How
it would be possible ??

 

[Barb Reinhardt]

I just used data validation yesterday for a date. What exactly do you want
to check?

"Little Master" <[email protected]>
wrote in message
news:[email protected]...

 

[Peo Sjoblom]

Data>validation>allow custom and

=A1>=TODAY()


--

Regards,

Peo Sjoblom

"Little Master" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

Select B1
Data|Validation
Allow: Date
Data: Greater than or equal to
Start date: =A1
Or maybe:
Start Date: =Today()

 

[Little Master]

Thanks Dave & Peo, both of yours methods worked well for me. And yes
thanks to Brab also