View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrisso Chrisso is offline
external usenet poster
 
Posts: 110
Default Convert date like string to serial number

Hi All

Here is a simple question:

How can I turn a date-like string (e.g. "01/01/07") to its date
serial number equivalent (39083) using VB?

I can do this easily in Excel itself (using the VALULE formulae or
changing the cell type) but am struggling to do this in VB.

Thanks in advance for any ideas.

Chris