Autofilling Dates in Excel

Do you ever need to enter dates of all working days in your spreadsheet? Try entering a date into a cell, and then use the autofill handle to fill down or across. Initially, Excel will include all dates, including weekends, but you can change this by using the Autofill Options button. This button appears to the right of the last filled cell. Click on the Autofill Options button and select the Fill Weekdays option.