You can also press CtrlD to fill the formula down in a column. As you place your mouse cursor in the lower right corner youll see the cursor turn into a shape that looks like a plus sign. Select those cells drag the Fill Handle across the selected range and then click on the AutoFill Options.
To insert todays today use the shortcut CTRL.
Select a blank cell enter the below formula into it and then press the Ctrl Shift Enter keys. To auto generate a series of days weekdays months or years with a specific step this is what you need to do. To create a formula that will calculate todays date use the TODAY Function. If you choose Fill Weekdays from the Auto Fill Options however Excel will skip over any weekends.