Stumped on a Find (Date) Code

[fpskidmark]

Hi Excel Guru,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I'm having trouble with the code below:<o></o>
<o></o>

Sheets("DaysOff").Activate
On Error Resume Next
lastrow = Range("bg113").End(xlUp).Row
For vv20 = 4 To lastrow
t = Sheets("DaysOff").Cells(vv20, "bg").Value
ee20 = Workbooks("RCO Schedule.xls").Sheets("2012").Range("c86:gd86").Find(t).Column: Workbooks("RCO Schedule.xls").Sheets("2012").Cells(161, ee20).FormulaR1C1 = "x"
Next vv20

<o></o>
<o></o>
The code works, but when T (the Date value) equals 1/1/2012, 1/2/2012, etc... "X" is populated on the November calendar (11/1/2012, 11/2/2012, etc). Why is that?<o></o>
<o></o>
I have tried to change the code to read: <o></o>

ee20 = Workbooks("RCO Schedule.xls").Sheets("2012").Range("c86:gd86").Find(format(t, "mm/dd/yyyy").Column:

<o></o>
But it doesn't work.<o></o>
<o></o>
Any suggestions?<o></o>

 

[John_w]

Are your dates 1/1/2012 and 1/2/2012 in dd/mm/yyyy or in mm/dd/yyyy format? And what is the local date format set in Windows? See http://www.ozgrid.com/VBA/find-dates.htm

 

[fpskidmark]

The dates are formated as: mm/dd/yyyy. As per Windows,the short date format is mm/dd/yyyy