2 Replies Latest reply: May 15, 2014 9:57 AM by thecontroller _ RSS

    Converting a serial number to date format

    thecontroller _

      Hello,

       

      Recently, I used the function DateSerial1900() to convert a date(i.e. Oct 31,2007) into a serial number(i.e. 39386) in order to perform some calculations.  Now I would like to convert the resultant serial number back into a date.  Does anyone know how to do this?

       

      Thanks,