Find date on another spreadsheet

[jiddings]

I'm confused on how to find a date in a column using VBA. Is there a special format statement that I need to use for the dates?
My problem:
I have a date in cell F17 in my source workbook. I want to find that date in my target workbook column A and return the row number.
I'd appreciate any help.... Thanks

Using Excel 2007

Thanks

 

[Trevor G]

Didn't need VBA as Match formula will work.

In cell G17 add this formula.

=MATCH(F17,[Book3]Sheet1!$A:$A,0)

Sample of both

Excel Workbook
	A
6	01/07/2011
7	02/07/2011
8	03/07/2011
9	04/07/2011
10	05/07/2011
11	06/07/2011
12	07/07/2011
13	08/07/2011
14	09/07/2011
15	10/07/2011
Sheet1

Formula in another workbook

Excel Workbook
	F	G
17	01/07/2011	6
Sheet1

 

[jiddings]

Trevor,
Thanks for the response.
I was attempting to do it in vba as two workbooks are involved.
I did figure out the vba. I overlooked the dates were values (each day of the year plus one from Jan. 1) and I needed to get values not dates.

 

[Trevor G]

IF you want to use the VBA then you need to jsut change the format of the cell to show the number rather than date.

Excel Workbook
	C
2	09/08/2011
Sheet2

Becomes

Excel Workbook
	C
2	40764
Sheet2

Code used

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Macro2()<br><SPAN style="color:#007F00">'</SPAN><br>    Range("C2").NumberFormat = "0"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>