# Category: Excel Functions

#### EXCEL TEXT Function to format Date and Time

Click here to download the file used for below exmaples TEXT Function: The TEXT function lets you change the way a number appears by applying formatting to it with format…

#### INDEX and Match in Excel

Click here to download the sample workbook used in the below examples. How to use INDEX and Match together in Excel. Firstly we see the syntax of Index and match…

#### Excel EDATE

Click Here to download the excel workbook which contains below examples. EDATE: This Function will help to calculate based upon one particular date the same date in the previous month…

#### Excel WORKDAY

Click here to download the excel workbook which contains below examples. Excel Workday Formula: This Formula will help to calculate the required working day date. Example suppose if I want…

#### Excel MATCH

Click here to download the Excel Workbook which contains below example Match Function: Excel Match function will help to lookup a particular value/text within lookup_array. In result, it will give…

#### How to get a ROMAN number in Excel (ROMAN and ARABIC Functions)

Click Here to download the Excel File which contains the Below Examples. Description of Functions ROMAN Function:- This Function will help to convert Arabic Numbers(1,2,3……..) to Roman Numbers(I, II, III,…

#### How to use VLOOKUP Function in Excel

Click Here to download the Excel File which contains the Below Examples. Description of VLOOKUP Function VLOOKUP: VLOOKUP means vertical lookup. This Function will help to get value from source…

#### Excel TIME and DATE functions Syntax List

Below the list of Excel TIME and DATE Functions, at bottom of the table links are provided to download this data in PDF and Excel Formats. S.No Function Syntax 1DATEDATE(year,month,day)…

#### How to use Excel IF Condition

Click here to download the excel file which contains below examples. Description of Excel IF Condition Function Excel IF Condition: This function will help to do a logical test and then…