When working with dates in a worksheet, it may be necessary to determine the number of days, weeks, months, or years between two provided dates. Calculate the difference between two given dates in Days You can use the following formulas to calculate the number of days that exist between two specific dates. Step 1 At first, you must create a sample data as shown in following screenshot. Step 2 Any one of the following formulas should be entered into a blank cell to generate the correct result. Formulas =DATEDIF(B3, C3, "D") Or, =C3-B3 Here, B3 is Start ... Read More

Conditional formatting, as we all know, will generate a rule that will decide which cells get formatted and how they should be formatted. It's possible that you'll wish to use the conditional formatting for per row at some point. Using conditional formatting, for instance, you might want to fill the background color of the cells in this area with a different color if cell A2 is greater than cell B2, A3 is greater than cell B3, and so on. Let’s understand step by step with an example. Step 1 At first, we must create a sample data, as shown in ... Read More

It is common for us to create and work on multiple Excel worksheets at the same time. The workbook could have separate worksheets for different years, products, and departments, or even the same workbook could have separate worksheets for multiple years, products, and departments. If you would like to share a part of a sheet or a single worksheet from the workbook with a colleague or boss or any other person, sometime you may need to email a part of the sheet. Although there may be alternatives to this way of doing things, in this tutorial, I am going to ... Read More

Excel 2019 enables users to incorporate not just numerical data but also images and graphics. Including pictures and other images is a terrific way to make your spreadsheets look more appealing. You can generate your own photos to add to a workbook or copy and paste images into a spreadsheet, much like you can in Microsoft Word. You can even create your own images to add. Excel gives you the ability to import graphics, shapes, symbols, and even 3D images and photos available on the web. Let's say that there are several pictures on a sheet, and they range in ... Read More

There are times when you may need to work on individual parts of a report that are part of a larger report, but you have to work on them individually. For example, if you complete a report weekly or monthly, you might have a tab for each report within the same Excel file. But those individual worksheets would possibly want to be published with headers and footers, and the same can be used for every worksheet. Even in case you are surely copying and pasting the equal factor to every sheet, there are a shockingly wide variety of steps concerned ... Read More

There are some circumstances in which you might want to create a horizontal line on another chart so that you can evaluate the current values in relation to the goal that you have set for yourself. It is possible to finish the challenge by plotting two distinct kinds of data points on the same graph. In earlier versions of Excel, combining two different chart types into a single chart was a laborious process that required multiple steps. The special Combo chart type that is included in Microsoft Excel 2013, Excel 2016, and Excel 2019 makes the process so astonishingly ... Read More

Excel is equipped with a number of functions that are designed to count various types of cells, including those that are blank, those that are not blank, those that contain numbers, dates, or text values, those that include certain words or characters, and so on. Excel's COUNTIF function is used to determine the number of cells inside a given range that fulfil the requirements of a certain condition. In the criteria, logical operators such as ">, value") In our example, we have selected the cell D2 and adding the following formula to it. =COUNTIF(C2:C10, ">20000") After pressing ... Read More

Excel provides a wide variety of options for generating a hyperlink. If you want to create a link to a certain website, all you have to do is write the URL of the page into a cell, press Enter, and Microsoft Excel will immediately transform your entry into a hyperlink that can be clicked on. You can use the Hyperlink context menu or the Ctrl + K shortcut to link to another worksheet in an Excel file, or you can link to a specific location in another Excel file. Utilizing a Hyperlink formula, which makes it simpler to generate, copy, ... Read More

The majority of spreadsheets contain a lot of numbers. There are several of them that have text. But you may also insert symbols and special characters in your spreadsheet if you want to personalize the information that is contained there and open up some interesting new possibilities. Excel treats them somewhat differently despite the fact that they are almost identical to one another. When inserting symbols, fractions, special characters, or international characters, the most important thing to grasp is that the font you use is critical. This is the most important thing to learn. There is a difference in ... Read More

Excel provides a variety of options for users who wish to insert symbols into their work. Utilizing the keyboard and the buttons on the Ribbon, creating a formula, and formatting cells are some examples of these. The Delta symbol is an example of a symbol that is frequently utilized in Excel. When presenting a change in numbers, you'll frequently find this on dashboards and scorecards created in Excel. The symbol ∆, known as the Delta, is the fourth letter of the Greek alphabet. In mathematics, it refers to change. In Excel, this symbol allows users to see how values change ... Read More