Here’s a simple dataset of some dates that we’ll convert into days of the week. Method 1 – Using the TEXT Function to Display the Day of the Week from a Date in Excel Steps Select cell C5. Apply the following formula: =TEXT(B5,"dddd") Note: You can use two variations: TEXT...
If you’re familiar with using Excel formulas and don’t mind adding a new column, you can use the TEXT function to display days instead of dates. This is handy if you plan to keep both the weekday and the date or just delete the original dates. Go to the first cell in the new c...
1. The WEEKDAY function below returns 2. 12/22/2025 falls on a Monday.2. You can also use the TEXT function to display the day of the week.3. Or create a custom date format (dddd) to display the day of the week. Cell A1 still contains a date.NETWORKDAYS...
Here, the SUM function will add 3 to the value in cell D5 (the End Date of the week before), and return the date of the 3rd day after that. Press ENTER to return the result. Drag the Fill Handle down to copy the formula to the cells below. We have all the Start Date values....
When designing your Excel calendar, you can use the =DATE(year,month,date) function to display the days of the week. Simply enter the year and the month's number somewhere in your spreadsheet and reference those cells in the formula. Of course, you could type the numbers directly in the...
To get a shorter version of the day names like "Mon" or "Tue", use this day of week code: =TEXT(A3, "ddd") PressEnter, and cell B3 will display the day name corresponding to the date in cell A3. It's important to note that the TEXT function always gives you theresult as text...
To copy the function to other cells,drag downwardsfrom the bottom-right corner of the cell where you typed the function. Related:How to Sort by Date in Microsoft Excel Find the Day of the Week as a Name To display a date's day of the week as the day name, like Monday, use Exce...
Change date to only display day of week in cells with Format Cells function You can change multiple dates to day of week with the following steps: 1. Select the range that you want to change the dates. 2. Then right click and choose Format Cells from the context menu, see screenshot:...
17 1 for Sunday to 7 for Saturday Note: From Excel 2010 onwards, 11 to 17 return type values were introduced. How to Use the WEEKDAY Function in Excel? This WEEKDAY Function is very simple easy to use. Let us now see how to use the WEEKDAY Function in Excel with the help of some...
Here's how to use the TODAY function in Excel: Step 1Open a new Excel worksheet. Step 2In a cell, type "=TODAY()". insert formula Step 3Press Enter to display the current date in the cell. result example Note: When your worksheet is updated to reflect the current date, the date ...