title: VBA equivalent of DATEVALUE?
body: <p>The formula function of =DATEVALUE and VBA's DateValue() provide exclusive results. How can I format a date in VBA to obtain the same serialization as I would by using =DATEVALUE?</p>
  
  <p><strong>Example:</strong> <code>1/19/2016</code>, formatted "m/d/yyyy", will return <code>42388</code> through <code>=DATEVALUE()</code></p>