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(B5,”dddd”) : This formula will show the entire day’s name in the result cell ...
To find the day of the week from a date, you have basically three ways. The first method is to turn your date into the day of the week in a numerical form. In this method, Sunday is displayed as number 1, Monday is number 2, and so on. This is calculated with Excel's WEEK...
Excel 是一款强大的数据分析和处理工具,其中一项常见任务是从给定日期中提取星期几。无论您是管理日程安排、分析趋势还是准备报告,了解如何从日期得出星期几都非常有用。以下是一份详细指南,可帮助您高效地从任何日期返回星期几。 使用文本函数返回日期中的星期几 使用Kutools for Excel 从日期返回星期几 使用格式单元格...
The Excel WEEKDAY function obtains the day of the week from a date but displays it as a number. By default, 1 is for Sunday, 2 is for Monday, and so on. You would use the following formula to get the day of the week for the date in cell B2. =WEEKDAY(B2) As you can see, ...
=CHOOSE(WEEKDAY(A3), "Su","Mo","Tu","We","Th","Fr","Sa") Display day of week from date using custom format Another way to show the day names in Excel is by applying acustom number format. This approach allows you to keep the original date value in the cell while visually disp...
Another dialog box will pop out. SelectColumnsinSeries in,DatefromTypeoptions, and Weekday fromDate unit. PressOK. This will return the workdays of the week. Read More:How to AutoFill Months in Excel Method 3 – Autofill Workdays Based on a Date with Excel WORKDAY and SEQUENCE Functions ...
=WEEKDAY(DATE(2025, 1,1)) To use the day mapping other than the default Sun-Sat, enter an appropriate number in the second argument. For example, to start counting days from Monday, the formula is: =WEEKDAY(C4, 2) In the image below, all the formulas return the day of the week ...
How to format a Date so that only the day of the week is visible from that date Result Steps Right click the desired cell and click Format Cells Go to the Number tab and click the Custom category Unde ...
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...
excel公式求助..低版本用这个吧,受版本影响,如果结果不正常的话,要用三键输出公式。【CTRL+SHIFT+ENTER】=SUM(--(WEEKDAY(DATE(A1,1,1)+ROW(INDIRECT("1