XLVBA: find date in table

I have a spreadsheet with two worksheets:

worksheet 1 has a cell with a date (say, 11/05/01)
worksheet 2 has a large table which has dates in col A.

Using VBA, can someone tell me how I can find the date in the large table using the date in worksheet 1 as the variable.

Please note, I am new to VBA and will need simple explaination with examples preferably.

Thanks very much.