Setting the day of the week by date in Microsoft Excel. Examples of use of features day with dayders and days in Excel How to configure the date and time on the computer

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

Unfortunately, this indicator lacks the record of the week. In fact, it is easy to correct, bringing the date and time display format in the view, convenient to us.

How to Change Date / Time Display Format

Step 1. Click on the right mouse button on the system tray, where the date and time indicators are located and select the "Setting date and time setting" item.

Step 2. The Date and Time window opens, where you click on the "Change Date and Time" button.

Step 3. In the Time Settings window, click on the "Changing Calendar Settings" link.

Step 4. The "Format Setup" window opens, in which we can change the date or time display format. We are interested in the input field "Brief Date", which will be used on the standard size panel.

Below, there are explanations on the control structures. In particular, we are interested in displaying the day of the week. These are the characters "DDD" for a short day of the week (Mon, W., Wed, etc.) or "DDDD" for full (Monday, Tuesday, Wednesday, etc.).

Press the "OK" button.

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

If we need a more complete description of the day of the week, change the date of the day as "DDDD" in the DDDD display format window.

In addition, an arbitrary text can be added in the format description field, and not just control structures.

Thus, they considered the question of how to add a day of the week to hours on the taskbar.

See also:

Did you like the material?
Exercise:

Schedule:

When working in Excel, the task is sometimes raised so that after entering a specific date in the cell, the day of the week, which corresponds to it. Naturally, it is possible to solve this task through such a powerful table processor as an exile, 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 for the entered date, ranging from the formatting of the cells and ending with the use of functions. Let's take a look at all existing options for performing the specified operation in Excele so that the user can choose the best of them for a specific situation.

Method 1: application formatting

First of all, let's see how the cell formatting can be displayed the day of the week for the entered date. This option implies the date conversion to the specified value, and not storing the display of both of these data types on the sheet.

In field "A type" formatting windows instead of value DDDD You can also enter the expression:

In this case, the list will show the abbreviated name of the day of the week.

Method 2: Using Function Text

But the method that was presented above provides for the date transformation on the day of the week. Is there any option so that both of these values \u200b\u200bare displayed on the sheet? That is, if in one cell we enter the date, then the day of the week should be displayed. Yes, this option exists. It can be done with the help of the formula TEXT. In this case, the value you need will be displayed in the specified cell in the text format.

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

Method 3: Application of the function of the day

There is another operator who can bring the day of the week for a given date. This feature Double. True, she displays the name of the day of the week, but his number. At the same time, the user can be installed from what day (from Sunday or Monday) the numbering will be counted.

As with the previous function, the date of the week's day is automatically changed when the date is changed in the cell in which the operator is installed.

As you can see, there are three main options for the date of the week in Excele. All of them are relatively simple and do not require some specific skills from the user. One of them is to apply special formats, and two others use embedded functions to achieve these purposes. Considering that the mechanism and method of displaying data in each of the described case differ significantly, the user must choose which of the specified options in a particular situation is suitable for all.

Good day to all ... In this small post, we will analyze the way in Windows 8.1 to set the display of the week of the week next to the clock. The developers have added this useful function to the OS, the withdrawal of the day of the week (current, respectively). In the lower right corner. Where the system time is displayed, (even on the taskbar).

But there is a little drawback. By default, this feature is not very convenient. In order for you to see the name of the day of the week. It will be necessary to unscrew the taskbar and to stretch it in height. Thereby cutting the desktop area (which actually neither is good). Here is an example.

In order not to be such inconvenience, it is necessary to make some non-cunning manipulations. Left-click on the system time and, in the window that opens, click on "Changing the date and time settings".

After clicking on the "Change of calendar parameters"

In the window that opens, on the Date tab, on the "Brief Date" point, we need to add three English DDD letters through the space, from the default value (DD). After that, click "apply" and "ok".

I want to draw your attention to the fact that three letters DDD will show us the abbreviated name of the day of the week.

But already four DDDD beeps will be launched a complete word.

I prefer to stay in the first version. The location of the day can be changed, on the left and right of the hours themselves, it is if you change the position of the DDDD characters, before or after a short date.

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

1) First of all, you must open the control panel. To do this, click on the start button with the right mouse button, or call the Win + X key combination menu. We choose the item we need and in the window that opens, in the section "Clock, language and region" find the link " Change dates, time and numbers»:

3) In the next window, the first thing you need to go to the tab " date" Now you can proceed to add the day of the week to the system tray. To do this, in the "Brief Date" at the very beginning write three English letters dDD. Through the gap from the default value. After changes, you must click " Apply"And" OK ", the result will instantly reflect 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 "W" will be shown "Tuesday".

In Windows, there is an opportunity to display on the clock not the screen not only the date, but also a lot of other useful information, for example, the day of the week or some kind of message. Of course, it will be required not to all users, but some can like it. This article will tell you how to properly configure the clock in the operating system.

Control panel and its elements

The clock is on the taskbar in the system tray. In general, it is customary to put those programs to which the user often refers to this panel. This allows you to reduce their search for and increases the efficiency of work.

As usual, in order to see the day of the week, it is required to hover the cursor on the clock and hold it there for some time. After that, a pop-up window appears 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, you can configure the panel so that the day of the week will be displayed immediately.

How to get the day of the week

For the clock began to display the necessary information, the user will need to do several actions. To begin with, go to the control panel, and from there proceed to regional standards.

On the first tab of the opening window, you will need to proceed to additional parameters.

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

You can change the date format not only through the standard control panel settings, it can also be done via the registry editor. To open it, press Win + R and enter the REGEDIT. In the window that opens, go along the HKEY_CURRENT_USER / CONTROL PANEL / INTERNATIONAL route. In the last directory you need to find the Sshortdate variable. The conditional designations of the date and time format are also exhibited as its value. Here, the user can replace them with the necessary to him, after which save changes. Time format will also change.

Legend date format

To properly configure time display, the user must know about what the all these cuts indicate that it will be written in detail in this section.

1. dDDD - Pliness writes the name of the day of the week: Sunday, Saturday, etc.;
2. dDD is the same information, but in the abbreviated version: Mon, W, Wed. etc.;
3. yyyy - shows full designation of the year: 2016, 2017, etc.;
4. yy - Displays only the last two digits from the year: 17, 18, 19;
5. M is the most brief numerical designation of the month: 3, 4, 5, etc.;
6. MM - displays two digits: 04, 05, 11, etc.;
7. MMM - a brief letter description of the month: Saint, Oct, etc.;
8. MMMM - Fully shows a month: June, July, November

Features of the Display of the Day of the Week

However, the user should know that the change in the time display format will change the values \u200b\u200bnot only on the clock in the tray. Now all the data data will be displayed as well. That is, information about when the folder was created, it will now also include information about the day of the week. If the month is displayed now by its full name, then in all other data it will also be shown.

So, if he does not want to see this, you will have to accept the inconvenience when working with the system clock. If you did not like 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, only instead of changing the settings, you will need to click on the Reset button.

How to configure the date and time on the computer

The simplest way to make changes to the date and time will be the use of the system trad itself. It needs to click on the clock, after which a small window with a calendar will open. In his bottom, there will be a small string "Changing the date and time settings", the user is worth clicking on it, after which the window opens with the parameters.

In this window, you can change the date and time for this, click on the appropriate button. However, to make such actions you need to have administrator rights. Low below, you can set the time zone. On other tabs, you can configure time synchronization with the Internet, or add one more hours that can display another time, for example, in another time zone. It may be useful for those who work with other regions and countries.

How to output the clock on the computer screen

In this section, it will also briefly tell about how to withdraw the clock on the desktop.

Watch disappeared from the system tray

In some cases, it happens that the required icons disappear from the right place. To return them to go to the control panel, find the "Notification Area" icons ", and in the window that opens, click on" Enable or Disable System Icons ". Here you can return to the place what is necessary for the user. In the top ten, the desired partition, instead of the control panel, is in the parameters - the system.

We bring clock to your desktop

For their output to the screen, in the seven and eight there are built-in gadgets. It is enough to right-click on the desktop and select the appropriate partition, after which the user can pull out the standard clock and calendar on the screen.

In the top ten there is no function, however, there is a Windows Desktop Gadgets utility (Gadgets Revived), which is able to return all standard gadgets in the same way as before. If this is not satisfied with this, you can always find third-party utilities on the Internet, which will display time on the screen in the form in which it is more convenient.