If you type your dates in a different format than the one supported by your geographic location -- for example, "2012-12" in the U.S. -- Excel won't interpret your entry as a date.

Microsoft Excel has a feature that allows you to convert a number into a date, which is quite simple to do. This tutorial explains the steps to convert a number into a date format in Excel.