The day is represented by the integer portion of the date serial number, while the time is represented by the decimal portion. The date serial number 1 begins on January 1, 1900, i.e. 1/1/1900 has a date serial number of 1. Caution! After February 28, 1900, Excel dates are one day out.