Introduction DAY function in Excel is a type of DATE/TIME function. It gives value of the day of month numbering between 1 and 31. This function can be applied to find the number of the day from the date present in the cell. This can also be used to extract and put the number of the day into other functions READ MORE

## How to use Excel COLUMNS function

Introduction COLUMNS function in excel is a lookup or reference function. It provides us with number of COLUMNS in an array or reference. We have to enter a range in Excel format and it returns number of COLUMNS present in that range. For example row A1:C6 gives 3 as the result. Syntax =COLUMNS(Array) Arguments array– It can be the READ MORE

## How to use Excel DATEDIF Function

Introduction DATEDIF function in Excel is a type of DATE/TIME function. This function helps us in finding difference between two dates in form of month or year or day. It is bifurcated as (DATE+DIFEERENCE). We get in return a number representing time interval between the dates. Syntax =DATEDIF(START-DATE, END-DATE,UNIT) Arguments START-DATE:- This is the start date and should be written READ MORE

## How to use excel DATE function

Introduction DATE function in Excel is a type of DATE/TIME function. It is used to make a date from given year, month, day which are provided individually. It can also be used as an assembler of dates which are changed from time to time based on values in the worksheet. Syntax =DATE(YEAR, MONTH,DAY) Arguments YEAR – It is a number READ MORE

## How to use Excel COLUMN function

Introduction COLUMN function in excel is a reference function. It returns the COLUMN number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =COLUMN(C9)returns 3 as C9 is the 3RD Column in Excel. Syntax =COLUMN(Reference) Arguments Reference– It is READ MORE

## How to use Excel CHOOSE function

Introduction CHOOSE function in excel is a lookup function. It is to retrieve a value from a table of values. It can retrieve up to 251 values from a list based on an index number. For example, if 1 to 12 represents number of months in a year then CHOOSE retrieves a month whose value is entered in the index READ MORE

## How to Correct VLOOKUP error (#N/A,#REF!,#VALUE!,#NAME?)

This article explains different errors which VLOOKUP result can show, reasons for the same and how to handle VLOOKUP error. In addition to this, the precaution to be taken while using VLOOKUP to get correct result is also explained. #N/A error in VLOOKUP #REF! Error in VLOOKUP #VALUE! Error in VLOOKUP #NAME? Error in VLOOKUP #N/A error in VLOOKUP #N/A error occurs READ MORE

## How to highlight selected cell in excel

Recently I received a question from our reader through our facebook page about how to highlight selected cell in excel with color. I have crated this short VBA codes for following to answer his question: VBA code to highlight selected cell in a single sheet. VBA code to highlight selected cell in all sheets VBA code to highlight active row READ MORE

## Remove Extra Spaces from Lookup Values: VLOOKUP with TRIM

While using VLOOKUP formula, if the data consists extra spaces , we may not get the results. VLOOKUP checks for exact match and even single extra space in data also will not give the results and will show #N/A error. But VLOOKUP is not case sensitive. In this article we will explain how to use VLOOKUP with TRIM to remove READ MORE

## VLOOKUP column index auto update with COLUMN function

In VLOOKUP formula, column index defines the column number of table from which the data is to be retrieved in results. When we have to put VLOOKUP formula for many columns from same source table, we can use $ sign to lock the cell reference in formula. This will help us to drag the formula to all columns without editing READ MORE