On a windows PC, excel stores dates as the number of days since January 1, 1900. For a date such as 9/15/2007, excel actually stores the value 39,340, but it formats the date to show you a value such as 9/15/2007. Try this: – 1. Enter the number 1 in cell A1. 2. Select cell … Read more