Excel handles dates and times numerically. The numbers for dates range from 1 to 2958465, with 1 indicating January 1, 1900, and 2958465 indicating December 31, 9999.
To see the serial number behind a date:
Press Ctrl+` (the ` key is to the left of the 1 key) to change the display of the cell’s contents.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.