Formula Archives - Page 4 of 15

How to use Excel WORKDAY.INTL function

Introduction WORKDAY.INTL function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax .This function is different from WORKDAY function as it allows to edit days which should be considered as weekends This function was introduced in Excel 2007 and is built in later versions.…

How to use Excel WEEKNUM Function

Introduction WEEKNUM function in Excel is a type of DATE/TIME function. This function converts a date into a number from 1 to 54 which represents number of the week. By default, first day of the week is Sunday. This function can also be used with other functions for inserting the day of the week. Syntax =WEEKNUMS(Serial_Number, Return_Type) Arguments Serial_Number: It is the date for which number of the week needs to be found.Return_Type: It is the number which represents week…

How to use Excel SEARCH, SEARCHB Function

Introduction SEARCH, SEARCHB function are text/string function in excel. These are used to locate one text string inside another text string and return its position. It is different from FIND function as it allows wildcards and also not case sensitive. SEARCHB is different from SEARCH only in case of DBCS language setting, otherwise they both behave as same. Syntax =SEARCH(Find_Text, Within_Text, Start_Num ) =SEARCHB(Find_Text, Within_Text, Start_Num ) Arguments Find_Text: The text or reference to the cell containing the text, whose…

How to use Excel TRIM Function to remove extra space

Introduction TRIM function are text/string function in excel. TRIM function is used to eliminate additional spaces from a text and it allows one space to remain between words. It can also be used to omit extra space which have appeared from data copied from other platforms which had irregular spacing. Syntax =TRIM( Text) Arguments Text: It is the text or reference to a cell containing the text whose extra spacing needs to be removed. Keynotes This function is useful for…

How to use excel TIME function

Introduction TIME function in Excel is a type of TIME/TIME function. It is used to make a time from given hour, minute, second which are provided individually. It can also be used as an assembler of times which are changed from time to time based on values in the worksheet. Syntax =TIME(HOUR, MINUTE,SECOND) Arguments HOUR – It is a number having value between 1 and 24 digits which represents the specified hour.MINUTE - This represents the number of minutes of…

How to use Excel NETWORKDAYS Function

Introduction NETWORKDAYS function in Excel is a type of DATE/TIME function. It gives value of the number of DAYS falling between two dates. This function can be applied to find the number of the days from the date present in the cell. This can also be used to extract and put the number of days into other functions, for example in DATE function. It skips weekends (Sundays and Saturdays) and can also omit any extra holidays if required. Syntax =NETWORKDAYS(Start_date,…

How to use Excel WEEKDAY Function

Introduction WEEKDAY function in Excel is a type of DATE/TIME function. This function converts a date into a number from 1 to 7 which represents day of the week. For example, 1 represents Sunday and 2 represents Monday and 7 represents Saturday. This function can also be used with other functions for inserting the day of the week. Syntax =WEEKDAY(Serial_Number, Return_Type) Arguments Serial_Number: It is the date for which day of the week needs to be found.Return_Type: It is the…

How to use Excel OFFSET function

Introduction OFFSET function in excel is a reference function. This function is used to refer data from a cell or range of cells to a defined range. The number of rows and columns to be returned is also specified. Reference returned by offset function is in parts: start point, row and column offset and height and width in rows and columns. It is also used with function which use dynamic calculation values. Syntax =OFFSET (Reference, Rows, Cols, Height, Width) Argument…

How to use Excel NUMBERVALUE Function

Introduction NUMBERVALUE is a text/string function. This function is used to convert text into number with decimals and separator values in it. For example, =NUMBERVALUE(“2000.990”, “,”, “.”), it gives 2000.99 as the answer. This is a worksheet function and can be entered into the cell in which you wants answer. Syntax =NUMBERVALUE(Text, decimal_separator, group_separator) Arguments Text: It is the text which will be converted into number.Decimal_Separator: It is the character used as decimal separator in the text.Group_Separator: It is the…

How to use Excel FALSE Function

Introduction FALSE in excel is a built in logical type function. This function is used to return logical FALSE value. It acts as a worksheet function and can be entered in cell of a worksheet. Syntax =FALSE( ) Arguments There are no arguments for the FALSE. Keynotes FALSE function does not have any arguments and simply returns the Boolean FALSE value.It is a compatibility function. Examples In this example, some numbers are entered in column A and in Column B…

Cart