G
Ginger
I need to check a cell to see that it does not contain a certain date. There
are 12 dates that the cell cannot be.
B12 = Date that I am testing to make sure that it isn't one of the dates in
my formula.
I have tried =IF(OR(B12<>"4-5-2009", B12<>"5-7-2009", "Y","N")
I can't get this to work. The cell format for B12 is "5-Apr-2009.
That differs from what appears in the top box when I click on the cell. It
shows as 4/5/2009. Could that make a difference? I have tried both ways,
and I can't get this to work. Any help would be greatly appreciated!
Thanks,
Ginger
are 12 dates that the cell cannot be.
B12 = Date that I am testing to make sure that it isn't one of the dates in
my formula.
I have tried =IF(OR(B12<>"4-5-2009", B12<>"5-7-2009", "Y","N")
I can't get this to work. The cell format for B12 is "5-Apr-2009.
That differs from what appears in the top box when I click on the cell. It
shows as 4/5/2009. Could that make a difference? I have tried both ways,
and I can't get this to work. Any help would be greatly appreciated!
Thanks,
Ginger