Hướng dẫn Excel

How to get the day of the week from a date in Excel

Converting a date into a day name (like Monday) or a number (1-7) is a common task in Excel. You can achieve this easily using built-in functions.

Từng bước

1
Select a cell
Click on the cell where you want the day of the week to appear.
2
Enter the formula
Type =TEXT(A1, "dddd") to get the full day name, or =WEEKDAY(A1) to get a number representing the day.
3
Press Enter
Press the Enter key on your keyboard to apply the formula and see the result.

=TEXT(A1, "dddd")

Use "ddd" in the TEXT function for a short day name (e.g., Mon) instead of the full name.
The WEEKDAY function returns 1 for Sunday by default; use the second argument to change this behavior.

What is the difference between TEXT and WEEKDAY?

TEXT returns the name of the day (e.g., Monday), while WEEKDAY returns a numeric value (1-7).