If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

Microsoft Excel handles dates as numbers, even though they display as dates -- for example, the date "10/10/2011" is really stored as "40826." This makes it difficult to directly add or subtract ...