How can I use Autofill to fill in days of the week in Excel?

By /

Autofill is a convenient feature in Microsoft Excel that allows users to quickly and accurately fill in data without having to manually input each value. In order to use Autofill to fill in the days of the week in Excel, the user will need to first enter the first day of the week (i.e. Monday) into a cell. The user can then click and drag the fill handle in the bottom right corner of the cell to automatically fill in the remaining days of the week in chronological order. This eliminates the need for repetitive data entry and ensures accuracy in the day sequence. Additionally, Autofill can be used to fill in other types of data, such as numbers or text, in a similar manner. Overall, Autofill is a useful tool for increasing efficiency and accuracy when working with data in Excel.

Autofill Days of the Week in Excel (3 Examples)

There are three common ways to autofill days of the week in Excel:

Method 1: Autofill Each Day of the Week

  • e.g. Sunday, Monday, Tuesday, Wednesday, …

Method 2: Autofill Weekdays Only

  • e.g. Monday, Tuesday, Wednesday, Thursday, Friday, Monday, …

Method 3: Autofill Weekday Dates Only (Skipping Weekend Dates)

  • e.g. 2/1/2024, 2/2/2024, 2/5/2024, 2/6/2024, …

The following examples show how to use each of these methods in practice.

Example 1: Autofill Each Day of the Week

To autofill each day of the week, simply type the name of the first day you’d like to start with.

For example, we’ll type “Sunday” into cell A1:

Next, hover over the bottom right hand corner of cell A1 until a tiny cross ( + ) appears and then simply click and drag down to more cells in column A to automatically fill in the days of the week:

Each day of the week will be displayed in column A:

Note that if you keep dragging the list further, the days of the week will start over on Sunday again.

Example 2: Autofill Weekdays Only

To autofill weekday only, type out the list of weekdays:

Then copy and paste this list once more in column A:

Then highlight the entire list and click and drag down to remaining cells in column A to autofill only weekdays:

This will autofill weekdays and skip weekends:

Example 3: Autofill Weekday Dates Only (Skipping Weekend Dates)

To autofill weekday dates only and skip weekends, enter the first date you’d like to start with in cell A1:

Then type the following formula into cell A2:

=WORKDAY.INTL(A1,1,"0000011")

Then click and drag the formula in cell A2 down to as many cells as you’d like in column A:

The resulting list of dates only include weekdays.

We can verify this by manually looking at a calendar and seeing that each of the dates in the list only fall on weekdays:

Note: You can find the complete documentation for the WORKDAY.INTL function in Excel .

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

x

Related terms:

  1. Autofill Days of the Week in Excel (3 Examples)
  2. How can I use Autofill to automatically fill in letters of the alphabet in Google Sheets?
  3. How can I autofill letters of the alphabet in Excel?
  4. Excel: Autofill Cells Based on Value in Another Cell
  5. Autofill Letters of the Alphabet in Excel
  6. How can I autofill values in Excel from another sheet?
  7. How to AutoFill Dates in Excel (3 Examples)
  8. How can I use Excel to automatically fill cells based on the value in another cell?
  9. What is the last day of the week in Excel and how do I find it?
  10. Google Sheets: How to Autofill Values from Another Sheet