Windows.  Viruses.  Notebooks.  Internet.  office.  Utilities.  Drivers

Few people know that Windows 10 has one useful feature - displaying the current day of the week next to the date and time. This feature is especially useful for those users who often have a question - what day is it today? Our next instruction will help to close it once and for all, and this does not require serious knowledge of the computer and 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 step is to go to the tab " date". Now you can start adding the day of the week to the system tray. To do this, in the "Short Date" at the very beginning, write three English letters ddd separated by a space from the default value. After making changes, 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 displayed.

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

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

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 the "Set date and time" item.

Step 2. The "Date and time" window opens, where we click on the "Change date and time" button.

Step 3. In the date time 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 taskbar of a standard size.

Below are explanations of the control structures. In particular, we are interested in displaying the day of the week. These are the characters "ddd" for the short day of the week (Mon, Tue, Wed, etc.) or "dddd" for the full day (Monday, Tuesday, Wednesday, etc.).

Press the "OK" button.

We will see that the date is now displayed in the system tray along with the day of the week. In our example, this is "Thu."

If we need more Full description day of the week, change the date display format setting window to "dddd".

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

Thus, we have 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:


Rate:

For charting or other analysis, the spreadsheet editor sometimes needs to display the day of the week in Excel in a date cell. This can be done in several ways. Each of which will be described separately.

In this case, using the functions built into Excel, the entered data in date format is converted to the day of the week. First you need to enter information in the cell: . Right-clicking on a cell will display context menu, in which you need to select the "Format" item. In the window that appears, on the NUMBER tab, you need to select the line "all formats" from the proposed options.

Next, in the right window, you will need to enter the value DDDD. The Sample field will automatically display the day of the week corresponding to the previously entered date. In the editor, the contents of the line have changed, but if you hover over it and click left button mouse, only the date will be displayed in the formula bar. You can also take the string DDD as the formatting type, which converts the content into the abbreviated name of the day of the week (Tuesday - Tue, Wednesday - Wed, etc.)

Option #2: Using the TEXT function to get the day of the week in Excel

The Excel editor, combined with the necessary formatting functions, is a versatile spreadsheet tool. To convert the date, enter it in the selected cell and select any free area on the sheet. To the left of the "Formula Bar" field is the "Insert Function" button. After clicking on it with the left mouse button, the settings window will appear:

  • You need to select the value "Text" from the list of categories.
  • In the list of available functions, select the option called TEXT and press OK to proceed to the input of arguments.
  • In the parameters, two fields are marked for setting: value and format. As the first, the address of the cell with the date is entered. This can be done manually or put the cursor in the right place and click the left mouse button. After that, the address should automatically appear in the "Value" line.
  • In the "Format" field, you will need to enter the expressions DDDD or DDD (for standard text abbreviation) and agree with the arguments.

Thus, two values ​​of the same type appear on the sheet, but in a different format: the date and the name of the day of the week corresponding to it. This method allows you to use the data in a compatible way. When the date is changed, the value of the day of the week is also converted. In the formula bar, you can manually set functions to speed up the editing process: \u003d TEXT (A1, "DDDD").

Option #3: Inserting a WEEKDAY Function

This function is similar to the previous one, but it converts a text value to a numeric value. In this case, the user has advanced options: setting the start of the countdown to one of the two selected days - Monday and Sunday. To enter, you need to go through the following procedure:

  • Select the cell where the converted value will be placed.
  • Enter the settings of the function wizard and select the "Date and time" line from the category catalog.
  • From the list presented, you will need a function WEEKDAY, whose arguments are "date in numeric format" and type.
  • As the first one, you need to enter the required date DD.MM.YYYY. For convenience, you can specify the address of the cell with the corresponding content.
  • The TYPE argument takes three values: 1, 2, 3. If you specify one, the days of the week will be counted from Sunday. Two is Monday. Three - the countdown starts from Monday, which will be taken by the counter as "0" (that is, Tuesday will be displayed as "1").

For manual entry in the formula bar, you need to write: \u003d WEEK DAY (A3; 2). It is not necessary to specify the TYPE parameter. If it is absent, the editor sets the default value to "1". This is true for the UK and other English-speaking countries, where the week starts on Sunday. In the CIS countries, you will need to enter the parameter yourself each time the function is activated.

The use of operators is due to the wide functionality, since when the date value changes, the contents of the cell with the function are also converted. When working with tabular databases, this is the best format conversion method to get the value of the day of the week in Excel.

Share our article on your social networks:

In windows, it is possible to display on the clock not only the date, but also many other things. useful information, for example, the day of the week or some message. Of course, not all users will need this, but some may like it. This article will talk about how to properly set the clock in the operating system.

Control panel and its elements

The clock is located on the taskbar in the system tray. In general, it is customary to place on this panel those programs that the user often accesses. This reduces the search time and increases work efficiency.

In normal mode, in order to see the day of the week, you need to hover over the clock and hold it there for some time. After that, a pop-up window will appear in which the day of the week will be written. Or you can click on the clock and go to the calendar, where you can also see the required information. However, it is possible to set the panel so that the day of the week is displayed immediately.

How to display the day of the week

In order for the watch to start displaying the necessary information, the user will need to do several actions. First you need to go to the Control Panel, and from there go to Regional Settings.

On the first tab of the window that opens, you will need to go to additional options.

In this section, you will have to go to the Date section, which contains all the settings necessary for the user. Here you need to set the data type, the same as in the picture. Detailed description image formats will be given in the following sections of the article.

You can change the date format not only through standard settings control panel, it can also be done through the registry editor. To open it, press win+r and type regedit. In the window that opens, follow the route HKEY_CURRENT_USER/Control Panel/International. In the last directory you need to find the sShortDate variable. The date and time format conventions are also set as its value. Here the user can replace them with the ones he needs, and then save the changes. The time format will also change.

Date format conventions

For correct setting displaying time, the user must be aware of what all these abbreviations mean, and this will be described in detail in this section.

  1. dddd - fully writes the name of the day of the week: Sunday, Saturday, etc .;
  2. ddd - displays the same information, but in an abbreviated form: Mon, Tue, Wed. etc.;
  3. yyyy - shows the full year designation: 2016, 2017, etc.;
  4. yy - displays only the last two digits of the year: 17, 18, 19;
  5. M - the shortest numerical designation of the month: 3, 4, 5, etc.;
  6. MM - displays two digits: 04, 05, 11, etc.;
  7. MMM - a short letter description of the month: Sept, Oct, etc.;
  8. MMMM - shows the month in full: June, July, November

Features of displaying the day of the week

However, the user should be aware that changing the time display format will change the values ​​not only on the clock in the tray. Now all date data will be displayed as well. That is, information about when the folder was created will now also include information about the day of the week. If the month is now displayed with its full name, then it will be displayed in all other data as well.

So, if he does not want to see this, he will have to put up with the inconvenience when working with the system clock. If you don't like the new settings, you can return all the default settings. To do this, you will need to go to the same settings as in the second section of the article, but instead of changing the settings, you will need to click on the Reset button.

How to set the date and time on your computer

The easiest way to make changes to the date and time is to use the system tray itself. In it you need to click on the clock, after which a small window with a calendar will open. At its very bottom there will be a small line "Change date and time settings", the user should click on it, after which a window with parameters will open.

In this window, you can change the date and time by clicking on the corresponding button. However, to perform such an action, you must have administrator rights. Below you can set the time zone. On other tabs, you can set up time synchronization with the Internet, or add another clock that can display a different time, for example, in a different time zone. This may be useful to those who work with other regions and countries.

How to display the clock on the computer screen

This section will also briefly talk about how to display the clock on the desktop.

Clock disappeared from system tray

In some cases, it happens that the required icons disappear from the right place. To return them, you need to go to the control panel, find the "Notification area icons" section, and in the window that opens, click on "Turn system icons on or off." Here it will be possible to return to the place what the user needs. top ten desired section, instead of the control panel is located in Settings - System.

Display the clock on the desktop

To display them on the screen, the seven and eight have built-in gadgets. It is enough to right-click on the desktop and select the appropriate section, after which the user will be able to pull out the standard clock and calendar on the screen.

There is no such function in the top ten, however, there is Windows utility Desktop Gadgets (Gadgets Revived), which is able to return all standard gadgets in the same form as before. If this does not suit the user, then you can always find it on the Internet. third party utilities, which will display the time on the screen in the form in which it is more convenient for him.

Good day to all ... In this short post, we will analyze how to set the display of the day of the week next to the clock in Windows 8.1. The developers added this to the OS useful feature, 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 here. By default, this function is not very convenient. To show you 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 ​​\u200b\u200bthe desktop (which, in fact, is not good). Here is an example.

In order to avoid such inconvenience, it is necessary to do a few tricky 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 want to draw your attention to the fact that the three letters ddd will show us the abbreviated name of the day of the week.

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

I prefer to stay on 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 characters, before or after the short date.

If you notice an error, select a piece of text and press Ctrl + Enter
SHARE: