## Add days to date in Excel excluding weekends and holidays (4 ways)

In this tutorial, we shall discuss how to add days to date in Excel excluding weekends and holidays. I shall show several methods. Use that method that best suits your requirement. Download ...

## How to calculate working days in Excel excluding weekends & holidays

It is often required in Excel to find out the total number of working days between two dates. Usually while counting this, we often neglect the weekends and holidays. Excel has two different ...

## IF Function with 3 Conditions

In this tutorial, we will be working on the nested if function in Excel. We will analyze the If function with 3 conditions in Excel. Here we will see the examples of multiple if functions along with ...

## How to Calculate Variance in Excel

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the measurement on how the numbers of data are distributed ...

## How to Compare Two Columns or Lists in Excel

While doing different tasks in Excel we often come across a situation where the matching and differences of two or multiple columns are required. It's not a difficult task to compare two lists in ...

## How to Use Excel EDATE Function

Excel provides a wide variety of functions to handle date calculations. We have already looked at some of these functions in previous tutorials. The EDATE function is utilized, when one wants to add ...

## How to Use the DATEDIF Function in Excel

Performing operations and calculations involving dates requires that one acquires familiarity with some of Excel’s Date and Time Functions. The DATEDIF worksheet Function in Excel calculates the ...

## MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

Excel provides functions to calculate the largest or maximum value in a range and also functions to calculate the smallest or minimum value in a range. The first function we are going to look at ...

## How to Use the Excel OR Function

The OR Function is a logical Function, that evaluates two or more conditions and returns true if at least one of the conditions is true. If all of the conditions are found to be false, then the OR ...

## How to Use the HLOOKUP Function in Excel

We have already seen how to utilize the VLOOKUP Function in a previous tutorial. We are now going to see how to use the HLOOKUP Function. HLOOKUP stands for horizontal lookup and is used when the ...

## How to Use XOR Function in Excel [With Example]

The XOR Function is a logical function that was introduced in Excel 2013 and later versions. The XOR Function if used with two conditions and one of the conditions evaluates to true, then the XOR ...

## How to Use the CEILING.MATH and the FLOOR.MATH Function in Excel

The CEILING.MATH Function is a new function that was introduced in Excel 2013 and later versions. The CEILING.MATH Function rounds a specified number up to the nearest integer or nearest specified ...

## How to Use Excel ROUND, ROUNDUP, ROUNDDOWN, MROUND & CEILING Functions

Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are namely the ROUND Function, the ROUNDUP Function, the ROUNDDOWN Function, the MROUND Function and ...