title: .FIND not finding the date
body: <p>vartype(Date_var)  is 8 which is Vbstring. vbtype of Newsheet.Range(&quot;B5&quot;) is 7 which is vbdate and the values are as follows. Date_var = 20211207,Newsheet.Range(&quot;B5&quot;) =  07/12/2021 and after numberformat it is converted to 20211207. Though the date is present, .Find is unable to get the column number. I tried converting date_var to Cdate and I am getting Type mismatch. Any help is much appreciated.</p>
  <pre><code>    Date_var = Worksheets(&quot;sheet1&quot;).Range(&quot;AF1:AL1000&quot;).Cells(1, 4).Value
      
      If Date_var = &quot;&quot; And Lastrow = 1 Then
         Exit Sub
      End If
      
      With Newsheet.Range(&quot;B5:BL5&quot;)
         .NumberFormat = &quot;yyyymmdd&quot;
          Set Columnfind = .Find(What:=Date_var, LookIn:=xlValues, lookat:=xlPart, 
          MatchCase:=False, SearchFormat:=False)
          If Columnfind Is Nothing Then
             colnum = 0
          Else
             colnum = Columnfind.Column
        End If
       
      End With
  </code></pre>