# Excel Functions Guide | ExtendOffice

## Database |
## Description |
## Arguments |

DAVERAGE |
Return average that match the specific criteria. | Database, Field, Criteria |

## Date and Time |
## Description |
## Arguments |

DATE |
Create date with year, month and day | year, month, day |

DATEDIF |
Return the years, months or days between two dates | start_date, end_date, unit |

DATEVALUE |
Convert a date stored as text format to a valid date | date_text |

DAY |
Get the day as a number (1 to 31) from a date | date |

DAYS |
Get the number of days between two dates | start_date, end_date |

DAYS360 |
Get the number of days between 2 dates in a 360-day year | start_date, end_date, method |

EDATE |
Add n months for a date | start_date, months |

EOMONTH |
Get the last day of month n months in future or past | start_date, months |

ISOWEEKNUM |
Get ISO week number from a given date | date |

HOUR |
Get the hour as a number (0 to 23) from a date time | Serial_number |

MINUTE |
Return the minute as number (0 to 59) from time | serial_number |

MONTH |
Get the month as integer number (1 to 12) from date | serial_number |

NETWORKDAYS |
Get the number of working days between two dates | Start_date, End_date, Holidays |

NETWORKDAYS.INTL |
Get workdays between two dates | Start_date, End_date, Weekend, Holidays |

NOW |
Get the current date and time | |

SECOND |
Return the seconds as number (0 to 59) from time | serial_number |

TIME |
Create time with hours, minutes and seconds | Hour, Minute, Second |

TIMEVALUE |
Get time from a text string | time_text |

TODAY |
Get the current date | |

WEEKDAY |
Get day of the week as a number (1 to 7) from date | Serial_number, Return_type |

WEEKNUM |
Returns the week number of the given date in a year | Serial_number, [Return_type] |

WORKDAY |
Adds workdays to the given start date and returns a workday | Start_date, Days, [Holidays] |

WORKDAY.INTL |
Adds workdays to the given start date and returns a workday excluding custom weekend and holidays | Start_date, Days, [Weekend], [Holidays] |

YEAR |
Returns the year based on the given date in a 4-digit serial number format | Serial_number |

YEARFRAC |
Calculates the fractional year in a decimal format between given dates | Start_daye, End_date, [Basis] |

## Lookup and Reference |
## Description |
## Arguments |

ADDRESS |
Return the cell address reference by column number and row number. | Row_num, Column_num, Abs_num, A1, Sheet_text |

AREAS |
Return the number of areas that make up the reference | Reference |

CHOOSE |
Return a value from the list of value argument by the given index number | Index_num, Value1, [Value2] |

COLUMN |
Return the number of column which formula appears or the column number of given reference | Reference |

COLUMNS |
Return the total number of columns in a given array or reference | Array |

FORMULATEXT |
Return a formula as a text string from a given reference | Reference |

GETPIVOTDATA |
Return data based on the pivot table structure | data_field, pivot_table, [field1, item1] |

HLOOKUP |
Look up a value in table by matching first row | Value, Table, Row_index, [Range_lookup] |

HYPERLINK |
Create a hyperlink which links to a given web page, a cell reference | Link_location, [Friendly_name] |

INDEX |
Returns the displayed value based on a given position from a range or an array | Array, Row_num, [Col_num], [Area_num] |

INDIRECT |
Convert a text string to a valid reference | ref_text, a1 |

LOOKUP |
Find certain value in a one-column range | lookup_value, lookup_vector, [result_vector] |

MATCH |
Get the position of an item in an array | lookup_value, lookup_array, [match_type] |

MMULT |
Return the matrix products of two arrays | Array1, Array2 |

OFFSET |
Return a reference offset from a starting point | Reference, Rows, Cols, [height], [width] |

ROW |
Return row number of a reference | [reference] |

ROWS |
Return the number of rows in a reference or an array | Array |

TRANSPOSE |
Rotate the orientation of a range or array | Array |

VLOOKUP |
Lookup a value in a table by matching on the first column and return value from a certain column | lookup_value, Table_array, Col_index, [Range_lookup] |

## Financial |
## Description |
## Arguments |

FV |
Figure out the future value of an investment | rate, nper, pmt, pv, type |

FVSCHEDULE |
Figure out future value of a lump sum investment with adjustable interest rates | principal, Schedule |

INTRATE |
Figure out the interest rate for a fully invested security | Settlement, Maturity, Investment, Redemption, Basis |

IRR |
Figure out the internal rate of return for a series of cash flows that occur at regular intervals | Values, Guess |

ISPMT |
Figure out interest payment of given period of an investment or loan | rate, Per, nper, pv |

MDURATION |
Figure out the modified Macauley duration for a security | settlement, Maturity, Coupon, Yld, Frequency, Basis |

MIRR |
Figure out modified internal rate of return for a series of cash flows | Values, Finance_rate, Reinvest_rate |

IPMT |
Figure out the interest payment for the specified period for an investment or load | rate, per, Nper, fv, type |

## Math |
## Description |
## Arguments |

ABS |
Return the absolute value of number. | Number |

AGGREGATE |
Return based on the specific used function. | Function_num, Options, Ref1, [Ref2] |

ARABIC |
Return an arabic number by the given roman number. | Text |

ASIN |
Return an angle of triangle in radians. | Number |

CEILING |
Round number up to nearest multiple | Number, Multiple |

CEILING.MATH |
Round number up to nearest multiple or nearest integer | Number, [Significance], [Mode] |

CEILING.PRECISE |
Round number up to nearest multiple or nearest integer ignoring sign of number | Number, [Significance] |

COS |
Return the cosine of an angle given in radians. | Number |

DECIMAL |
Return decimal number. | Text, Radix |

DEGREES |
Return an angle in degrees. | Angle |

SUMIF |
Return the summation for a list of numbers based on the specific criteria. | Range, Criteria, Sum_range |

SUMIFS |
Return the summation for a list of numbers that meet all specific criteria. | Sum_range, Range1, Criteria1, ... |

SUMPRODUCT |
Return the result of multiplied and summed arrays. | Array1, Array2, ... |

TAN |
Return the tangent value of an angle. | Number |

TRUNC |
Return a truncated number based on a given precision. | Number, Mum_digits |

## Logical |
## Description |
## Arguments |

AND |
Test multiple conditions to return True or False. | Logical1, Logical2, ... |

FALSE |
Generate the logical FALSE value. | |

IF |
Test for a specific condition. | logical_test, value_if_true, value_if_false |

IFERROR |
Trap and deal with errors. | value, value_if_error |

IFNA |
Trap and deal with #N/A errors. | value, value_if_na |

IFS |
Test multiple conditions to return the first match. | test1, value1, test2,value2, ... |

NOT |
Reverse the arguments or results. | logical |

OR |
Test multiple conditions with OR. | logical1, logical2, ... |

SWITCH |
Match multiple values, but return the first match. | expression, value1,result1, value2,result2, ..., default |

TRUE |
Generate the logical TRUE value | |

XOR |
Perform the exclusive OR function. | logical1, logical2, ... |

## Statistical |
## Description |
## Arguments |

COUNT |
Return the number of cells contain numbers. | Value1, [Value2] |

COUNTA |
Return the number of cells excluding empty cells. | Value1, [Value2] |

COUNTBLANK |
Return the number of empty cells. | Range |

COUNTIF |
Return the number of cells that meet a criterion. | Range, Criteria |

COUNTIFS |
Return the number of cells that meet multiple critera. | Criteria_range1, Criteria1, ... |

## Text |
## Description |
## Arguments |

CHAR |
Return the character specified by a number. | Number |

CLEAN |
Remove all non-printable characters from the given text. | Text |

CODE |
Return a numeric code of the first character in a given text string. | Text |

CONCAT |
Join texts from multiple columns, rows or ranges together. | Text1, Text2, ... |

CONCATENATE |
Join two or more texts items from multiple cells into one. | Text1, Text2, ... |

DOLLAR |
Convert a number to text in the currency formatting. | Number, Decimals |

EXACT |
Returns TRUE if two compared strings are exactly same, or returns FALSE. | Text1, Text2 |

FIND |
Returns the starting position of a string inside another one. | Find_text, Within_text, Start_num |

FIXED |
Returns a number formatted as decimals and represented as text. | Number, Decimal_places, No_commas |

LEFT |
Extracts string from left of the text string. | Text, Num_chars |

LEN |
Count the number of characters. | Text |

LOWER |
Lowercase letters in the text string. | Text |

SUBSTITUTE |
Replace text based on given text. | text, new_text, old_text, [instance_num] |

TEXT |
Convert number to text with a specific format. | text, format_text |

TEXTJOIN |
Join multiple values with specific delimiter | delimiter, ignore_empty, text1, [text2]... |

TRIM |
Remove extra spaces from text string | text |

UNICHAR |
Return the Unicode character based on given number. | number |

UNICODE |
Return the number based on the first character of given text. | text |

UPPER |
Convert all letters of a given text to uppercase. | text |

VALUE |
Convert text to a number. | text |

MID |
Return the specific characters from the middle of text string. | text, start_num, num_chars |

NUMBERVALUE |
Return the real number from number is stored as text. | text, decimal_separator, group_separator |

PROPER |
Convert text strings to proper case. | text |

REPLACE |
Find and replace characters based on given location from text string with a new text. | old_text, start_num, num_chars, new_text |

REPT |
Return the repeated text by specific number of times. | text, number_times |

RIGHT |
Extract the text from right of the text string. | text, num_chars |

SEARCH |
Return the location of the specific character or text from the given text string. | find_text, within_text, start_num |