Need Help

[Deepwater]

I have some dates in sheet 1 from cell A2 to A20 and want to verify the current date in sheet2 cell B4 falls in the list enterd sheet1 cell A2 to A20. if the current date is in the list ,then i wnat choose "0" other wise '1" . How can i achive this.

Thanks in advance

[Domenic]

Try...

=IF(B4<>"",IF(COUNTIF(Sheet1!A2:A20,B4),0,1),"")

Hope this helps!