Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The number of days in a leap year is 366, whereas the number of days in a common year is 365. As is general knowledge, there are both leap years and common years. To determine, from a given date, the total number of days that comprise a month or a year. When you have a list of dates organised in a column, you can use the formulas given in this tutorial to compute the number of days in each month. Let’s understand step by step with an example. Step 1 In the first step, Let’s assume we have a sample ... Read More
When you ask someone in regular conversation, "How old are you?" the expectation is that they will provide a response that indicates the number of years they have been living. You are able to construct a formula in Microsoft Excel that can accurately compute an individual's age in months, days, hours, and even minutes. But since we're being traditional here, let's start with learning how to compute age based on date of birth in years. If we know a person's birth date, we can use a formula to determine their age. However, have you ever considered using Excel to determine ... Read More
Follow the steps given below to understand clearly how to calculate the median in a range in a Microsoft Excel sheet. Step 1 Open a Microsoft Excel sheet, and enter the data as shown in below you can also enter the data as per your wish. Step 2 Now select a blank cell and type the below given formula in order to calculate the median and then press enter key to get the median in the cell. =MEDIAN(A1:A6) Note − In the above‑mentioned formula, A1:A6 represents the range that you want to calculate the median ... Read More
Whenever you work for a certain organization, you need to log in and log out at the starting and end of every workday, and counting the total working hours, minus the lunch time of a day will make it quick for you to calculate the salary based on the amount of time you have worked. I have the following daily attendance record, which has the log-in time, the log-out time, the start time, and the end time of lunch each day in a worksheet. Now, I want to calculate the total hours worked each day with the lunch time minus. ... Read More
Spreadsheets allow Excel's powerful data visualisation and analysis software to manage, store, and display massive amounts of data in a graphical format. Excel is a powerful data visualisation and analysis software. Each individual piece of data is saved inside of a cell, which is a square or rectangular block. Creating graphs using this tool allows users to visualise patterns, compare data, and gain insights from the data by utilising functions and formulas. Its primary application is in the field of accounting; however, anyone can use it for a wide variety of jobs so long as the requirements are met. ... Read More
The Easter celebration is usually celebrated on the first Sunday that follows the first ecclesiastical full moon that falls on or after March 21. Because of this, the date of Easter might vary from year to year. This tutorial may be of assistance to you if you are looking for the particular day of Easter for a given year. Here we will use a formula in determining when Easter will fall on any given year. Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a sample data for calculating easter ... Read More
How would you find out how many days are left till your next birthday, if it is something you are interested in? Actually, if you are counting down the days till your next birthday with Microsoft Excel, you may utilise the worksheet formulae to make the process much simpler. Let’s understand step by step with an example. Step 1 Make a worksheet where the Headers are displayed below. Create column headings in a worksheet in a sequential order, as demonstrated in the screenshot below. In addition, enter your date of birth into the cell labelled "DOB " in column ... Read More
At times, you may want to know the working days left in a month or in a year. So, if you want to calculate the remaining days left in a month or to calculate the remaining days left in a year you can follow the below article which is easy and quick to calculate the days left in a month or in a year in an Excel sheet. Follow the steps given below to calculate the days or working days left in a month. Step 1 Open an Excel sheet and enter the date for which you want to calculate ... Read More
For you to calculate the compound annual growth rate (CAGR) in an Excel sheet, there is a basic formula that you need to follow =(End Value/Start Value)^(1/Periods)-1 you can easily apply this formula for this kindly follow the below steps − Step 1 Open a Microsoft excel sheet and enter the data as shown in below. You can change the data as per your requirement. Kindly find the below screenshot for your reference. Step 2 Now you need to select a blank cell and enter the below given formula into the blank cell and press the enter key so ... Read More
You know how to calculate the normal average function which gives the average value of all the selected cells in an excel sheet. But in this article, you will learn how to calculate the average excluding the min and max values or highest and lowest values from selected numbers as shown below. You can calculate the average without max and min values in Microsoft excel using the formulas. Open a Microsoft excel sheet and enter the numbers as per your need as shown in the below screenshot for your reference. Now you need to enter the below-given formula and ... Read More