Your administrator may set up certain cells to contain date values. When you click into such a cell, a month calendar displays, from which you select a date. The date value then displays in the format set in preferences. For example, if the date format is MM/DD/YYYY and you select February 7 (in the year 2011), the date is processed as 02/07/2011. See Setting the Date Format.