title: convert date to date serial
body: <p>I'm trying to convert a date (date type) into a long. 
  This long should be something like the number of days since the 1 January 1900. 
  How to get this in VBA ? In excel I'm getting this automatically when i concatenate a date with a string.</p>