Doesn't show the date next to the clock. How to enable the day of the week display in the taskbar

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, it is possible to solve this problem using such a powerful spreadsheet processor as Excel, and 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 all the existing options for 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 specified value rather than keeping both of these types of data displayed on the worksheet.

In the 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 for a 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 the date is changed, 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 the use of 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 these options is most suitable for him in a particular situation.

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 added this to the OS useful function, output of 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.

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.

Features of the syntactic notation of the function DAY, WEEKDAY and DAYS in Excel

The DAY function has the following syntax:

DAY(date)

Takes as input a single parameter, date, which corresponds to the date whose day you want to determine.

Notes:

The input parameter is usually a cell from Excel tables, containing data in date format.
The results of calculations of the DATE function and other functions that return values in Date format are also accepted as input.
When directly entering data between function brackets (for example, =DAY(“06/24/2018”)), you must use quotes, thereby indicating that the data passed to the input is of the Text type. Next Excel produces automatic conversion data in Date format.
Error #VALUE! Will be generated if unsupported data was passed to the input of the DAY function Excel type, for example: DAY(“June 24-2018”) or DAY(“06/24/2018”).
The date parameter can be represented as a number in Excel time code.

The WEEKDAY function has the following syntax:

WEEKDAY(date,[type])

Description of function arguments:

Date is a required parameter corresponding to the date whose day of week you want to determine. This option has the features described in the notes for the previous feature.
Type – a number in the range from 1 to 3, indicating which day of the week is considered the first (in some countries the first day of the week is Sunday, in ours it is Monday). If type=1, the first day of the week will be Sunday, type=2 – Monday. If type=3, the result of the WEEKDAY function will be a number in the range from 0 to 6, where 0 corresponds to Monday.

Note: in some cases, instead of the numbers 1,2...7, the name of the day of the week (Monday, Tuesday...Sunday) is required. To do this, you can create the following table:

And then output the text value corresponding to the day of the week:

However, for this task you can use the following function: =TEXT(A2,"dddd").

The result of this function is the text “Sunday”. If required short note day of the week (Sat, Mon, Wed), “dddd” should be specified as the second parameter.

The DAYS function is used to calculate the number of days between two specified dates and has the following syntax: =DAYS(end_date, start_date).

Description of the arguments to this function:

End_date is a required parameter characterizing the end date of an event.
Start_date is a required parameter characterizing the start date of a certain event to perform the calculation.

Notes:

Calculating the number of days between dates converts the data to numbers in Excel time code. This means that the entries “=DAYS(“06/24/2018”;”06/13/2018”)” and “=DATEVALUE(“06/24/2018”)-DATEVALUE(“06/13/2018”)” will return the same values.
If one of the function's parameters represents a date written as text, it will be processed by the DATEVALUE function, which will return an integer date.
If the function's parameters are numbers whose values are outside those allowed in the Excel time code, a #VALUE! error will be generated.
If the DAYS function uses parameters as data that cannot be represented as dates in Excel, the #VALUE! error will be returned.

Examples of calculations in Excel using the functions DAY, WEEKDAY and DAYS

The table contains several dates written in the format Excel dates, in which employees of a certain enterprise must be paid wages. Due to accepted changes According to the law, employee salaries must be calculated on the first day of each month. It is necessary to correct the dates from 07/15/2018 to 07/01/2018. Part of the table looks like this:

To solve, we use the following formula: =B3-DAY(B3)+1.

Let's fill in the remaining columns in the same way. As a result, we get a new column with correct dates issuance of salaries:

Determination of working days and weekends using the WEEKDAY formula

Example 2. Software product reads data from an Excel spreadsheet and uses it in its calculations. One of the cells contains data in the Date format corresponding to the date the parcel was received. It is necessary to determine whether the specified date corresponds to a working day of the week (Mon to Fri) and return the logical value “true” or “false” (if it is a weekend) for further processing by the program.

The original table looks like this:

To determine the day of the week, we will use WEEKDAY, the first argument of which is the data from the “Date of Arrival” cell, and the second is 2 (counting the days of the week starts from one, which corresponds to Monday). To solve we use the following function:

As you can see, all dates are working days of the week.

Why do you need the DAYS function in Excel?

Example 3. It is well known that the Second World War began on June 22, 1941 and ended on May 9, 1945. It is necessary to determine how many days the hostilities took place.

Let's enter the initial data into the table:

To calculate, we use the following formula: =DAYS(B3,A3).

We get the following result:

That is, hostilities lasted for 1417 days.

Pay attention! Any date in Excel is the number of days that have passed since the date 01/01/1900. More details are described in the article: How to calculate a date in Excel? Therefore, you can freely use such a simple formula without functions: =B3-A3.

As you can see in the figure, the result is similar. In fact, the DAYS function in Excel is not needed at all.

To create charts or do other analysis, you sometimes need to display the day of the week in Excel in a date cell in a spreadsheet editor. There are several ways to do this. We will describe each of them separately.

In this case, using 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: . By click right button mouse on the cell will be displayed 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 the cursor over it and press the left mouse button, only the date will be displayed in the formula bar. You can also take the DDD string as a formatting type, which converts the content into an 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, in combination with the necessary formatting functions, is a universal tool for working with tables. To convert a date, enter it into 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, a settings window will appear:

You need to select “Text” from the list of categories.
On the list available functions select the option called TEXT and press OK to proceed to entering arguments.
In the parameters there are two fields to set: value and format. The address of the cell with the date is entered as the first one. This can be done manually or by placing the cursor in the desired location and clicking with the left mouse button. After this, 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 different formats: the date and the name of the day of the week corresponding to it. This method allows the data to be used in a compatible manner. When the date is changed, the day of the week value is also converted. You can manually set functions in the formula bar to speed up the editing process: =TEXT(A1,"DDDD").

Option #3: Inserting the WEEKDAY function

This function is similar to the previous one, but 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 two selected days - Monday and Sunday. To enter you need to go through the following procedure:

Select the cell in which the converted value will be placed.
Enter the Function Wizard settings and select the “Date and Time” line from the category catalog.
From the list presented, you will need the WEEKDAY function, the arguments of which 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 means Monday. Three – the countdown starts from Monday, which will be accepted by the counter as “0” (that is, Tuesday will be displayed as “1”).

To enter manually in the formula bar, you need to write: =WEEKDAY(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 Great Britain and other English-speaking countries, where the week begins on Sunday. In CIS countries, you will need to enter the parameter yourself each time you activate the function.

The use of operators is due to the wide range of functionality, because when the date value changes, the contents of the cell with the function are also converted. When working with tabular databases, this is the most optimal method for converting formats to obtain the day of the week value in Excel.

Share our article on your social networks: