How to display the day of the week automatically from the date.(Microsoft Excel)

Japanese version.

There are three main ways to automatically display the day of the week.

  • Autofill
  • Format cell
  • Function


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".

dddMon Tue Wed Thu Fri Sat Sun
ddddMonday Tuesday Wednesday Thursday Friday Saturday Sunday

It looks like text, but it is still a date (serial).


The TEXT function creates the following formula.


This method changes from date (serial) to text.



Tips. Others.(Microsoft Excel)