In our data-driven world, Excel remains a vital tool for organizing, analyzing, and visualizing information. One frequent use-case is determining the day of the week from a specific date. Whether you're scheduling events or analyzing trends based on days, knowing how to extract this information can be incredibly beneficial. Let's delve into four straightforward methods to achieve this in Excel.

Get Day of Week from a Date in Excel

• Using Format Cells: Directly modifies the original date to display the day of week
• Using Kutools: Allows swift toggling between various date formats, including the day of week
• Using TEXT Function: Displays the day of the week in a separate cell
• Using WEEKDAY Function: Returns the day of the week as a number (1 for Sunday, 2 for Monday, etc.)

Video: Find day of week from date

Get Day of Week from a Date in Excel

Here this tutorial will introduces 4 different ways on getting the day of the week from dates.

Using Format Cells: Directly modifies the original date to display the day of week

The Format Cells feature of Excel allows you to modify the dates to various formats including day of the week.

Step 1: Select dates and right click to choose Format Cells form contents menu

Step 2: Specify settings in Format Cells dialog

Under Number tab, select Custom , then go to the Type section, enter dddd into the textbox. Click OK.

Result:

Using Kutools: Allows swift toggling between various date formats, including the week of day

Beyond simply formatting dates as days of the week, you might want to display them in other styles, like showcasing only the month or perhaps just the day and month. This is where the Apply Date Formatting feature of Kutools for Excel comes in handy. With it, you can easily transform dates into a variety of formats, no need to memorize any codes – just a single click does the trick.

After installing Kutools for Excel, select the cells you want to handle, click Kutools > Format > Apply Date Formatting, then choose the date format you need from Date format list, and preview the result in right section. And then click OK.

Result

Using TEXT Function: Displays the day of the week in a separate cell

If you want to show dates as days of week in a separate cell without altering the original date, you can use the TEXT function.

Step 1： Select a cell that will place the day of week, apply below formula, and press Enter key

=TEXT(A2,"dddd")

Step 2：Drag fill handle down to cells for getting all results

Using WEEKDAY Function: Returns the day of the week as a number (1 for Sunday, 2 for Monday, etc.)

The WEEKDAY function in Excel provides the day of the week for a given date, represented as an integer. By default, this value ranges from 1 (indicating Sunday) to 7 (indicating Saturday).

Step 1： Select a cell that will place the day of week, apply below formula, and press Enter key

=WEEKDAY(A2,1)

Step 2：Drag fill handle down to cells for getting all results

Each of these methods has its unique advantages, depending on the specific needs of your Excel project. For more invaluable Excel tips and tricks that can transform your data processing, dive in here.