|...or with a date in A1, use =A1 in A2 and drag it down.|
If you need the dates "hard coded", select the cells with the formulas, then use:
Ctrl-c to Copy
This may be the long way for this particular case, but using formulas to fill cells then using PasteSpecial...Values is a powerful technique for filling cells with the values you need.
Let Excel do the work for you and then remove the formulas and lock in the values.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.