Custom Data Validation Formula not working

[laxminarayana]

I am trying to restrict certain dates in a cell using the following custom Data validation formula

if(H2=12/10/2013,12/25/2013,False)

But unable to achieve the desired result. i am sure there is a problem in formula. Can some one please correct the formula.

 

[RoryA]

What exactly is the formula meant to mean? If H2 should only be one of those two dates, use:
=OR(H2=date(2013,12,10),H2=date(2013,12,25))
If H2 should be between the two dates, use:
=AND(H2>=date(2013,12,10),H2<=date(2013,12,25))

 

[XOR LX]

Hi,

Try this instead:

=OR(H2=DATEVALUE("12/10/2013"),H2=DATEVALUE("25/12/2013"))

Regards

 

[laxminarayana]

Actually H2 should not be equal to the following dates
12/10/2013
12/25/2013

Thank you

 

[laxminarayana]

what formula should i use for the following case

Actually H2 should not be equal to the following dates
12/10/2013
12/25/2013

Thank you

 

[RoryA]

=NOT(OR(H2=date(2013,12,10),H2=date(2013,12,25)))

 

[laxminarayana]

Thank you very much rory.

 

[laxminarayana]

How to implement the same using vba ?

Thanks in advance.

 

[laxminarayana]

=NOT(OR(H2=date(2013,12,10),H2=date(2013,12,25)))

Thank you Rory.
The formula which you gave is working. But i have a big list of dates (holidays of 6 months) and the formula seems to be apt when, only few dates are to be restricted. So, is it possible to achieve desired result using vba ? If yes, can you please tell how the code should be ?

 

[RoryA]

If you have a list of dates, enter them in a range and then use:
=ISNA(MATCH(H2,your_date_cells,0))