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.

This article looks at a few ways to extract and present information about the day, month, and then year.

Excel automatically recognizes common formats, such as "3/17/2012," "Mar 17, 2012" or "17 Mar 2012." Use the Month function to extract the month number from a referenced cell.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.