Dates are extremely important in any business or personal situation, so Excel takes care to get them right. Excel understands dates no matter how you type them, so feel free to type them as needed. You can always change the formatting later.
Click the cell into which you want to enter the current date and time.See Also
For more information about formatting cells with dates, see "Formatting Cells Containing Dates".
Entering long series of data, such as days in the month, weekdays, or a series of numbers with a definite progression, is tedious. As you type or paste the data, it’s easy to forget which months have 31 days or on which day of the week the first of a month falls. Excel makes entering such series simple: With AutoFill, you can type a label or value in one cell and assign it to many other cells; type labels or values in two or more cells and have Excel extend the series based on the relationship of the two (or more) cell entries; or even extend dates by a day, a month, or a year.
Drag the Fill handle to the cell containing the last label or value in the series.Try This!
Type 1/1/2007 in cell A1 and drag the Fill handle across the cells you want to fill. Excel will fill your cells by increasing the day for every entry. Now click the AutoFill Options button that appears and click Fill Years.
Tip
If you hold down the Ctrl key as you drag the Fill handle, Excel changes how it fills in your series. For example, if dragging the Fill handle would normally copy a single value into the cells you drag over, dragging while holding down the Ctrl key would cause the value to increment (for example, dragging the Fill handle of a cell that contains the value "1" would increment the value to 2, then 3, and so on).
