How to display the day of the week automatically from the date.(Microsoft Excel)
There are three main ways to automatically display the day of the week.
- Autofill
- Format cell
- Function
Autofill
This method is valid only if the dates are in consecutive rows.
Enter the day of the week in the first cell and autofill that cell. It will then be automatically filled in.
Format cell
Set the following format in "Custom" under "Format Cells".
| Format | Result |
|---|---|
| ddd | Mon Tue Wed Thu Fri Sat Sun |
| dddd | Monday Tuesday Wednesday Thursday Friday Saturday Sunday |
It looks like text, but it is still a date (serial).
Function
The TEXT function creates the following formula.
=TEXT(Date,"ddd")
=TEXT(Date,"dddd")
This method changes from date (serial) to text.
---