• 24/04/2022
  • homesmartjp
  • 1506 Views

[Excel] How to display the date with the day of the week in the schedule table in Excel

How to use Excel that I can't hear anymore

I want to display the day of the week after the date!

Let's make a schedule table with the day of the week in Excel

After mid-December, many people may finally start thinking about the New Year's schedule. Why don't you use Excel to create the following schedule table (1) in order to properly manage work-related meetings, events, and private schedules.

Let's make such a schedule (①)

This time, I will explain how to display the date with the day of the week after the date in Excel.

Display the day of the week using a user-defined display format

Let's display the day of the week after the date in the date column (1) of the next "January 2022 schedule table" like "2022/1/1 (Sat)". Here, instead of actually writing the character string "2022/1/1 (Sat)" in solid, we will use the user-defined display format. When this function is used, the value entered in the cell remains "2022/1/1", but only the appearance is changed to "2022/1/1 (Sat)" or "January 1 (Sat)". can do. Let's do it now.

【Excel】エクセルでスケジュール表に曜日入りの日付を表示する方法

Let's display the day of the week after the date in the date column (1) of the "January 2022 schedule table" like "2022/1/1 (Sat)".

Enter "2022/1/1" (②) in cell A3. With cell A3 selected, click the button (④) at the bottom right of the [Numeric] group on the [Home] tab (③).

Enter "2022/1/1" (②) in A3 and click the button (④) at the bottom right of the [Numeric] group on the [Home] tab (③).

The Format Cell dialog box is displayed. Select [User Defined] (⑥) from the [Category] field on the [Display Format] tab (⑤), and enter "yyyy / m / d (aaa)" (⑦) in the [Type] field. This means that the date is displayed in the format "YYYY / M / D", followed by the initials of the day of the week in parentheses, such as "(Saturday)" for Saturday. A preview (⑧) is displayed in the [Sample] field, so check it.

After setting, click [OK] (⑨) to close the dialog box.

Select [User Defined] (⑥) from the [Category] field on the [Display Format] tab (⑤), and enter "yyyy / m / d (aaa)" (⑦) in the [Type] field. When the preview (⑧) is displayed in the [Sample] field, click [OK] (⑨) to close the dialog box.

When you return to the sheet, "2022/1/1 (Sat)" (⑩) is displayed in cell A3. The day of the week was displayed after the date. Looking at the formula bar, it is "2022/1/1" (⑪). You can see that the actual input value does not change, and only the appearance is displayed with the day of the week like "2022/1/1 (Sat)".

"2022/1/1 (Sat)" (⑩) is displayed in cell A3, and "2022/1/1" (⑪) is displayed in the formula bar.

Use the autofill feature to copy values ​​and formats to other cells in column A as well. When you move the mouse pointer to the lower right of cell A3, the shape of the mouse pointer changes, so drag it down as it is (⑫).

Place the mouse pointer on the lower right corner of cell A3 and drag it down (⑫).

You were able to enter the date for January until "2022/1/31 (Monday)" (⑬).

You have entered the date for January (⑬)

Get the date you want with a user-defined display format!

This time, I explained how to display the date with the day of the week after the date in Excel. You used a feature called user-defined display format. With this feature, you can enter the value in the cell as "2022/1/1" and display it in the date format you like.

In addition to this example, for example, if you enter "m" month "d" day "(aaa)" in the [Type] field of the [Format Cell] dialog box, "January 1st (Sat)" will be displayed. Can be displayed as. If you master this function, you will be able to display the date freely. Please try it once.