{"id":346,"date":"2018-06-27T17:35:03","date_gmt":"2018-06-27T17:35:03","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=346"},"modified":"2024-03-30T10:48:34","modified_gmt":"2024-03-30T10:48:34","slug":"how-excel-stores-date-and-time","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/how-excel-stores-date-and-time\/","title":{"rendered":"How Excel Stores Date and Time"},"content":{"rendered":"\n
If you want to use date and time efficiently in Excel, you first have to learn how Excel stores these values.<\/p>\n\n\n\n
At first, it may seem that Excel stores dates and times as text values (for example January 12, 2014<\/strong>). In fact, these values are nothing but numbers, formatted in a way that is easily recognizable by a person.<\/p>\n\n\n\n The date is stored as an integer. Excel starts counting dates from January 1, 1900 24:00:00<\/strong>, so the number 1 is treated as January 1, 1900<\/strong>, 2 is treated as January 2,<\/strong> 1900 <\/strong>and so on. Look at the following example.<\/p>\n\n\n\n January 1, 1900 = 1 <\/em><\/p>\n\n\n\n January 3, 1900 = 3 <\/em><\/p>\n\n\n\n February 2, 1901 = 399 <\/em><\/p>\n\n\n\n March 1, 2014 = 41699<\/em><\/p>\n\n\n\nDate<\/h2>\n\n\n\n
Example 1:<\/h3>\n\n\n\n
Time<\/h2>\n\n\n\n