Japanese version. There are three main ways to automatically display the day of the week. 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. This method changes from date (serial) to text. Links Tips. Others.(Microsoft Excel)