Excelhub 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 … Read more
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 … Read more
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: … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
Introduction LOOKUP function in excel is a lookup and reference function. This function is used to lookup or approximately match data in single column or single row and retrieve value from corresponding column or row. This function has two forms, one is called vector and the other one is called array form. Vector form Syntax … Read more