Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
This article briefs learners about the way to generate the same or the first day of the next month from the provided date in Excel. This article contains a stepwise explanation for both the discussed practices. The first example allows the learner to obtain the same-day date of the next month, this means if they pass “12-03-2023” as input then the generated output will be “12-05-2023”. Next example, allow leaner to get the first day of next month. This simply means if the input date “15-04-2023” then the generated output should be “01-05-2023”. Example 1: To get same day of ... Read More
Calculating the subtotal of an invoice is an important component of an invoice. It allows the user to understand the total amount after putting in the total invoice amount. In this article, the learner is guided through the process of generating a subtotal of the provided invoice number. For example, if invoice 101 has three entries of 100, 200, and 300, then the calculated subtotal amount will become 600. In this article, the user implements the Subtotal value by using the formula, method. Example 1: To get subtotals based on invoice numbers in Excel by using the formula: Step ... Read More
Excel spreadsheet store data in table format. Every Excel sheet is made up of rows and columns. Rows are the horizontal record fields available in the Excel sheet. On the other hand, columns are the vertical record fields available in the Excel sheet. Row address values are represented by using numbers. While column data values will be represented by using the alphabet. Since row data is represented by using numbers, therefore, they are required to be get converted into an alphabet value. While column data is already available in the form of letters. Example 1: To get row letter ... Read More
This article briefs learners about the way to generate the month-from-week number and year in Excel. This article describes two strategies to achieve the required task. The first example guides the learner to use the predefined methods, in the form of user-defined formulas. The second method guides the learner about the use of VBA code. Please note that VBA is a programming language that can work only when written properly within a proper format. This article contains stepwise explanations for both the discussed practices. Example 1: To get month from week number and year in Excel by using the formula: ... Read More
A workbook is a type of document used to organize and manage data or information in a structured format. MS Excel is also an example of a workbook. It is categorized as a software application used to process and manipulate data. This tutorial provides two examples to obtain the current workbook name. The first method is based on the use of VBA code. This method allows the user to define a module, to obtain the required output. On the other hand, the second method is based on the use of Kutool plus extension. Example 1 − To obtain the current ... Read More
End of month date means that end date of a provided month. For example if the provided data is “04-apr-2023”, then the last date of month will be “31-apr-2023”. This article focusses on using the predefined method to generate formula to obtain the last month date. Second example of the article is based on the use of “VBA code”. By using the VBA code, user is trained to write a function definition, and after that by calling the function user can easily generate the end date of month in excel. Example 1: To get the end of month date in ... Read More
Random values are used to obtain results. These results can be used to perform simulations, to understand the pattern of different system components. It is useful when users require a large data set to evaluate some common feature. Generating random yes or no can be useful for pole or opinion-related services. This article allows users to use two methods to generate random Yes or No. The first method is based on the use of predefined formulas presented in Excel. On the other hand, the second method is focused on using the kutool to make the work easier. Example 1: To ... Read More
How To Use jQuery To Calculate The Sum Calculating the sum of radio button values using jQuery involves selecting the radio buttons and attaching a click event listener. When a radio button is clicked, the value of each selected radio button is retrieved and added together. The resulting sum is then displayed in a designated element using jQuery's text() method. This process allows for the easy calculation and display of the sum of radio button values on a web page. Example $(function() { ... Read More
Forms components are one of the essential parts of web applications. The forms are used in the contact us pages, application page, etc. HTML offers us many different ways and options to customize the setups. This includes textarea, input, checkboxes, etc. This article will explain how to build a custom form control using HTML. Custom From Control Using HTML and CSS We can use only HTML and CSS to create a custom form control. However, more is needed to interact with the backend application with JavaScript. But still, we can create all the front-end effects using only HTML and ... Read More
Introduction Blending elements in CSS is a technique used to create interesting visual effects and enhance the design of a web page. With the mix-blend-mode property in CSS, you can control how an element blends with the content below it. In this article, we'll explore how to use mix-blend mode to blend elements in CSS. Understanding Mix-Blend-Mode mix-blend-mode is a CSS property that allows you to set the blending mode for an element. Blending modes determine how two elements blend together, with different modes producing different visual effects. By default, an element in CSS will have a blending mode of ... Read More