How to use Excel EDATE Function

This article explains the syntax and the use of the EDATE function in Microsoft Excel. The Excel EDATE function returns the serial number that represents...

How to use Excel Day Function

This article explains the syntax and the use of Excel DAY function in Excel. The Excel DAY function returns the day of the month from...

How to use RIGHT function in Microsoft Excel

The Excel RIGHT function returns one or more character, based on the specified number of characters from the end of a supplied text string. Syntax: =RIGHT(text,...

How to use Excel New IFS Function

In this tutorial, you’ll learn about newly introduced Excel IFS function that can be used as an alternative to the nested IF statements. You...

Randbetween Function in Microsoft Excel

Use RANDBETWEEN function to create random number between two numbers (bottom and top). Whenever we work on worksheet it calculates for new number every time....

How to use LEN Function in Microsoft Excel

The Excel LEN function is an in-built function hence frequently used in day to day life. The function is really simple and easy to...

How to use Excel MOD Function (Examples + Videos)

This article explains how to use Excel MOD function that returns a remainder after the division of one number by another. In other words,...

How to use Excel YEAR Function

This article explains the syntax and the use of Excel YEAR function in Excel. The Excel YEAR function returns a 4-digit integer representing the year...

How to use LEFT function in Microsoft Excel

LEFT function in Excel is used to extract one or more characters from the left side of a supplied text string. Syntax: =LEFT(text, num_chars) Arguments: text –...

How to use COLUMN Function in Microsoft Excel

In Microsoft Excel, COLUMN function returns the column number of the specified reference or first column of supplied reference. In case when no reference...