Excel Guides

AutoFilling with Weekdays in Excel

Assuming you would like a tutorial on how to autofill with weekdays in Excel:

To autofill with weekdays in Excel, first enter the starting day in the cell. For this example, we will use Monday, January 1, 2018. Then, drag the fill handle (the small black square in the bottom-right corner of the cell) down or to the right until all of the cells are filled with consecutive days.

If you want to skip weekends when autofilling, double-click the fill handle, and then click Auto Fill Options. Under Fill days, select Saturday and Sunday.

If you drag the fill handle to a cell that already contains a date, Excel fills the selected cells with sequential dates starting with the next day after the date in that cell.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.