Good day everyone... In this short post we will look at how to set the day of the week display next to the clock in Windows 8.1. The developers have added this useful function to the OS, displaying the day of the week (current, respectively). In the lower right corner. Where the system time is displayed (that is, on the taskbar).

But there is a small drawback. By default, this function is not very convenient. In order for you to see the name of the day of the week. You will need to unpin the taskbar and stretch it a little in height. Thus, we will reduce the area of ​​​​the desktop (which, in fact, is not good). Here's an example.

In order to avoid such inconveniences, it is necessary to make several simple manipulations. Left-click on the system time and in the window that opens, click on “Change date and time settings”.

Then click on “Change calendar settings”

In the window that opens, on the Date tab, opposite the “Short Date” item, we need to add three English letters ddd separated by a space, from the default value (dd). Then click “Apply” and “Ok”.

I would like to draw your attention to the fact that the three letters ddd will show us the abbreviated name of the day of the week.

But now four letters dddd will give us the full word.

I prefer to stay with the first option. The location of the day can be changed to the left and right of the clock itself, that is, if you change the position of the dddd symbols, before or after the short date.

When working in Excel program Sometimes the task is set so that after entering a specific date in a cell, the day of the week that corresponds to it is displayed. Naturally, decide this task through such a powerful spreadsheet processor as Excel, possibly in several ways. Let's see what options exist to perform this operation.

There are several ways to display the day of the week based on an entered date, ranging from formatting cells to using functions. Let's take a look at everything existing options performing the specified operation in Excel so that the user can choose the best one for a particular situation.

Method 1: Apply Formatting

First of all, let's see how you can use cell formatting to display the day of the week based on the entered date. This option involves converting the date to the specified value rather than keeping both of these types of data displayed in the worksheet.

In field "Type" formatting windows instead of value "DDDD" you can also enter the expression:

In this case, the sheet will display the abbreviated name of the day of the week.

Method 2: Using the TEXT function

But the method that was presented above involves converting the date to the day of the week. Is there an option to have both of these values ​​displayed on the sheet? That is, if we enter a date in one cell, then the day of the week should be displayed in another. Yes, such an option exists. This can be done using the formula TEXT. In this case, the value we need will be output to the specified cell in text format.

Moreover, if you change the date value in a cell, the day of the week will automatically change accordingly. Thus, by changing the date you can find out what day of the week it will fall on.

Method 3: Using the WEEKDAY function

There is another operator that can display the day of the week by given date. This is a function WEEKDAY. True, it does not display the name of the day of the week, but its number. In this case, the user can set from which day (Sunday or Monday) the numbering will be counted.

As with the previous function, when you change the date, the number of the day of the week in the cell in which the operator is installed automatically changes.

As you can see, in Excel there are three main options for representing a date as a day of the week. All of them are relatively simple and do not require the user to have any specific skills. One of them is to use special formats, and the other two use built-in functions to achieve these goals. Considering that the mechanism and method of displaying data in each described case are significantly different, the user must choose which of them. the above options in a particular situation it suits him most.

Few people know that Windows 10 has one useful feature– displays the current day of the week next to the date and time. This feature will be especially useful for those users who often have the question - what day is it today? Our next instruction will help close it once and for all, and this will not require serious computer knowledge or any additional software.

1) First of all, you need to open the Control Panel. To do this, click on the Start button right click mouse, or call the menu with the key combination WIN+X. We select the item we need and in the window that opens, in the “Clock, language and region” section we find the link “ Changing date, time, and number formats»:

3) In the next window, the first thing you need to do is go to the “ date" Now you can start adding the day of the week to the system tray. To do this, write three English letters at the very beginning of the “Short Date” ddd separated by a space from the default value. After the changes, you must click " Apply" and "Ok", the result will be instantly reflected on the screen:

4) By the way, the day can be indicated in abbreviated form, as well as in full, for this you already need to add four letters dddd, then for example, instead of “Tue”, “Tuesday” will be shown.

For the convenience of the user, indicators of the current time and date are located on the taskbar, in the system tray area.

Unfortunately, this indicator lacks a day of the week entry. In fact, this is easy to fix by bringing the date and time display format into a form that is convenient for us.

How to change the date/time display format

Step 1. Right-click on the system tray, where the date and time indicators are located, and select “Set date and time.”

Step 2. The “Date and Time” window opens, where we click on the “Change Date and Time” button.

Step 3. In the time and date settings window, click on the “Change calendar settings” link.

Step 4. The “Format Settings” window will open, in which we can change the format for displaying the date or time. We are interested in the “Short Date” input field, which will be applied to the standard size taskbar.

Below there are explanations on control structures. In particular, we are interested in displaying the day of the week. These are the symbols “ddd” for a short day of the week (Mon., Tue., Wed., etc.) or “dddd” for a long day (Monday, Tuesday, Wednesday, etc.).

Click the “Ok” button.

We will see that the system tray now displays the date along with the day of the week. In our example it is “Thu.”

If we need more Full description day of the week, change the date display format settings window to change the day as “dddd”.

In addition, you can add arbitrary text to the format description field, not just control constructs.

Thus, we considered the question of how to add the day of the week to the clock on the taskbar.

See also:

Did you like the material?
Share:

Please rate: