How to use Excel DAY Function

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

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