Hướng dẫn difference google sheets formula - công thức trang tính khác nhau của google

Calculates the number of days, months, or years between two dates.

Nội dung chính Show

Sample Usage
Number of days

Sample Usage

DATEDIF(DATE(1969, 7, 16), DATE(1969, 7, 24), "D")

DATEDIF(A1, A2, "YM")

DATEDIF("7/16/1969", "7/24/1969", "Y")

Syntax

DATEDIF(start_date, end_date, unit)

start_date - The start date to consider in the calculation. Must be a reference to a cell containing a DATE, a function returning a DATE type, or a number.
end_date - The end date to consider in the calculation. Must be a reference to a cell containing a DATE, a function returning a DATE type, or a number.
DATEDIF(A1, A2, "YM")0 - A text abbreviation for unit of time. For example,DATEDIF(A1, A2, "YM")1 for month. Accepted values are DATEDIF(A1, A2, "YM")2,DATEDIF(A1, A2, "YM")3,DATEDIF(A1, A2, "YM")4,DATEDIF(A1, A2, "YM")5,DATEDIF(A1, A2, "YM")6,DATEDIF(A1, A2, "YM")7.
- DATEDIF(A1, A2, "YM")2: the number of whole years between DATEDIF(A1, A2, "YM")9 and end_date.
- DATEDIF(A1, A2, "YM")3: the number of whole months between DATEDIF(A1, A2, "YM")9 and end_date.
- DATEDIF("7/16/1969", "7/24/1969", "Y")4: the number of days between DATEDIF("7/16/1969", "7/24/1969", "Y")5 and end_date.
- DATEDIF(A1, A2, "YM")5: the number of days between DATEDIF("7/16/1969", "7/24/1969", "Y")5 and end_date after subtracting whole months.
- DATEDIF(A1, A2, "YM")6: the number of whole months between DATEDIF(A1, A2, "YM")9 and end_date after subtracting whole years.
- DATEDIF(A1, A2, "YM")7: the number of days between DATEDIF("7/16/1969", "7/24/1969", "Y")5 and end_date, assuming start_date and end_date were no more than one year apart.

Notes

Months and years are only counted if they are equal to or go past the "day." For example, the function returns "4 months" between the dates 9/30/15 and 2/28/16 (even though the 28th is the last day of the month).
If DATEDIF(start_date, end_date, unit)8 produces a result in an unexpected format, ensure that no pre-existing format has been applied to the cell. For example, if DATEDIF(start_date, end_date, unit)9 returns start_date0, the start_date1 format has been applied to the cell. Change the format of the cell to start_date2 in order to view the expected result of start_date3.
Use DATEDIF(A1, A2, "YM")0 DATEDIF(A1, A2, "YM")5 to answer questions such as, "After subtracting whole years and whole months from my age, how many days old am I?"
Use DATEDIF(A1, A2, "YM")0 DATEDIF(A1, A2, "YM")6 to answer questions such as, "After subtracting whole years from my age, how many whole months old am I?"
Use DATEDIF(A1, A2, "YM")0 DATEDIF(A1, A2, "YM")7 to answer questions such as, "How many days has it been since my last birthday, given my birthdate and today's date?"

Examples

Make a copy

Note: Each example is in its own tab.

Number of days

In this example, DATEDIF(start_date, end_date, unit)8 returns the number of days in the Apollo 11 mission.

Months

In this example, DATEDIF(start_date, end_date, unit)8 returns the number of months in one year.

Was this helpful?

How can we improve it?

Date DATE DATE4 Converts a provided year, month, and day into a date. Learn more Date DATEDIF DATEDIF(start_date, end_date, unit) Calculates the number of days, months, or years between two dates. Learn more Date DATEVALUE DATE6 Converts a provided date string in a known format to a date value. Learn more Date DAY DATE7 Returns the day of the month that a specific date falls on, in numeric format. Learn more Date DAYS DATE8 Returns the number of days between two dates. Learn more. Date DAYS360 DATE9 Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more Date EDATE DATE0 Returns a date a specified number of months before or after another date. Learn more Date EOMONTH DATE1 Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more Date HOUR DATE2 Returns the hour component of a specific time, in numeric format. Learn more Date ISOWEEKNUM DATE3 Returns the number of the ISO week of the year where the provided date falls. Learn more Date MINUTE DATE4 Returns the minute component of a specific time, in numeric format. Learn more Date MONTH DATE5 Returns the month of the year a specific date falls in, in numeric format. Learn more Date NETWORKDAYS DATE6 Returns the number of net working days between two provided days. Learn more Date NETWORKDAYS.INTL DATE7 Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more Date NOW DATE8 Returns the current date and time as a date value. Learn more Date SECOND DATE9 Returns the second component of a specific time, in numeric format. Learn more Date TIME end_date0 Converts a provided hour, minute, and second into a time. Learn more Date TIMEVALUE end_date1 Returns the fraction of a 24-hour day the time represents. Learn more Date TODAY end_date2 Returns the current date as a date value. Learn more Date WEEKDAY end_date3 Returns a number representing the day of the week of the date provided. Learn more Date WEEKNUM end_date4 Returns a number representing the week of the year where the provided date falls. Learn more Date WORKDAY end_date5 Calculates the end date after a specified number of working days. Learn more Date WORKDAY.INTL end_date6 Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more Date YEAR end_date7 Returns the year specified by a given date. Learn more Date YEARFRAC end_date8 Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more Engineering BIN2DEC end_date9 Converts a signed binary number to decimal format. Learn more Engineering BIN2HEX DATE0 Converts a signed binary number to signed hexadecimal format. Learn more Engineering BIN2OCT DATE1 Converts a signed binary number to signed octal format. Learn more Engineering BITAND DATE2 Bitwise boolean AND of two numbers. Learn more. Engineering BITLSHIFT DATE3 Shifts the bits of the input a certain number of places to the left. Learn more. Engineering BITOR DATE4 Bitwise boolean OR of 2 numbers. Learn more. Engineering BITRSHIFT DATE5 Shifts the bits of the input a certain number of places to the right. Learn more. Engineering BITXOR DATE6 Bitwise XOR (exclusive OR) of 2 numbers. Learn more. Engineering COMPLEX DATE7 Creates a complex number given real and imaginary coefficients. Learn more Engineering DEC2BIN DATE8 Converts a decimal number to signed binary format. Learn more Engineering DEC2HEX DATE9 Converts a decimal number to signed hexadecimal format. Learn more Engineering DEC2OCT DATE0 Converts a decimal number to signed octal format. Learn more Engineering DELTA DATE1 Compare two numeric values, returning 1 if they're equal. Learn more Engineering ERF DATE2 The ERF function returns the integral of the Gauss error function over an interval of values. Learn more. Engineering ERF.PRECISE DATE3 See ERF Engineering GESTEP DATE4 Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. Learn more. Engineering HEX2BIN DATE5 Converts a signed hexadecimal number to signed binary format. Learn more Engineering HEX2DEC DATE6 Converts a signed hexadecimal number to decimal format. Learn more Engineering HEX2OCT DATE7 Converts a signed hexadecimal number to signed octal format. Learn more Engineering IMABS DATE8 Returns absolute value of a complex number. Learn more Engineering IMAGINARY DATE9 Returns the imaginary coefficient of a complex number. Learn more Engineering IMARGUMENT DATEDIF(A1, A2, "YM")00 The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more. Engineering IMCONJUGATE DATEDIF(A1, A2, "YM")01 Returns the complex conjugate of a number. Learn more Engineering IMCOS DATEDIF(A1, A2, "YM")02 The IMCOS function returns the cosine of the given complex number. Learn more. Engineering IMCOSH DATEDIF(A1, A2, "YM")03 Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more. Engineering IMCOT DATEDIF(A1, A2, "YM")04 Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more. Engineering IMCOTH DATEDIF(A1, A2, "YM")05 Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more. Engineering IMCSC DATEDIF(A1, A2, "YM")06 Returns the cosecant of the given complex number. Learn more. Engineering IMCSCH DATEDIF(A1, A2, "YM")07 Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more. Engineering IMDIV DATEDIF(A1, A2, "YM")08 Returns one complex number divided by another. Learn more Engineering IMEXP DATEDIF(A1, A2, "YM")09 Returns Euler's number, e (~2.718) raised to a complex power. Learn more. Engineering IMLOG DATEDIF(A1, A2, "YM")10 Returns the logarithm of a complex number for a specified base. Learn more. Engineering IMLOG10 DATEDIF(A1, A2, "YM")11 Returns the logarithm of a complex number with base 10. Learn more. Engineering IMLOG2 DATEDIF(A1, A2, "YM")12 Returns the logarithm of a complex number with base 2. Learn more. Engineering IMPRODUCT DATEDIF(A1, A2, "YM")13 Returns the result of multiplying a series of complex numbers together. Learn more Engineering IMREAL DATEDIF(A1, A2, "YM")14 Returns the real coefficient of a complex number. Learn more Engineering IMSEC DATEDIF(A1, A2, "YM")15 Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more. Engineering IMSECH DATEDIF(A1, A2, "YM")16 Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more. Engineering IMSIN DATEDIF(A1, A2, "YM")17 Returns the sine of the given complex number. Learn more. Engineering IMSINH DATEDIF(A1, A2, "YM")18 Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more. Engineering IMSUB DATEDIF(A1, A2, "YM")19 Returns the difference between two complex numbers. Learn more Engineering IMSUM DATEDIF(A1, A2, "YM")20 Returns the sum of a series of complex numbers. Learn more Engineering IMTAN DATEDIF(A1, A2, "YM")21 Returns the tangent of the given complex number. Learn more. Engineering IMTANH DATEDIF(A1, A2, "YM")22 Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more. Engineering OCT2BIN DATEDIF(A1, A2, "YM")23 Converts a signed octal number to signed binary format. Learn more Engineering OCT2DEC DATEDIF(A1, A2, "YM")24 Converts a signed octal number to decimal format. Learn more Engineering OCT2HEX DATEDIF(A1, A2, "YM")25 Converts a signed octal number to signed hexadecimal format. Learn more Filter FILTER DATEDIF(A1, A2, "YM")26 Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more Filter SORT DATEDIF(A1, A2, "YM")27 Sorts the rows of a given array or range by the values in one or more columns. Learn more Filter SORTN DATEDIF(A1, A2, "YM")28 Returns the first n items in a data set after performing a sort. Learn more Filter UNIQUE DATEDIF(A1, A2, "YM")29 Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more Financial ACCRINT DATEDIF(A1, A2, "YM")30 Calculates the accrued interest of a security that has periodic payments. Learn more Financial ACCRINTM DATEDIF(A1, A2, "YM")31 Calculates the accrued interest of a security that pays interest at maturity. Learn more Financial AMORLINC DATEDIF(A1, A2, "YM")32 Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more. Financial COUPDAYBS DATEDIF(A1, A2, "YM")33 Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more Financial COUPDAYS DATEDIF(A1, A2, "YM")34 Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more Financial COUPDAYSNC DATEDIF(A1, A2, "YM")35 Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more Financial COUPNCD DATEDIF(A1, A2, "YM")36 Calculates next coupon, or interest payment, date after the settlement date. Learn more Financial COUPNUM DATEDIF(A1, A2, "YM")37 Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more Financial COUPPCD DATEDIF(A1, A2, "YM")38 Calculates last coupon, or interest payment, date before the settlement date. Learn more Financial CUMIPMT DATEDIF(A1, A2, "YM")39 Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial CUMPRINC DATEDIF(A1, A2, "YM")40 Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial DB DATEDIF(A1, A2, "YM")41 Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more Financial DDB DATEDIF(A1, A2, "YM")42 Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more Financial DISC DATEDIF(A1, A2, "YM")43 Calculates the discount rate of a security based on price. Learn more Financial DOLLARDE DATEDIF(A1, A2, "YM")44 Converts a price quotation given as a decimal fraction into a decimal value. Learn more Financial DOLLARFR DATEDIF(A1, A2, "YM")45 Converts a price quotation given as a decimal value into a decimal fraction. Learn more Financial DURATION DATEDIF(A1, A2, "YM")46 . Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more Financial EFFECT DATEDIF(A1, A2, "YM")47 Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more Financial FV DATEDIF(A1, A2, "YM")48 Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial FVSCHEDULE DATEDIF(A1, A2, "YM")49 Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more Financial INTRATE DATEDIF(A1, A2, "YM")50 Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more Financial IPMT DATEDIF(A1, A2, "YM")51 Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial IRR DATEDIF(A1, A2, "YM")52 Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more Financial ISPMT DATEDIF(A1, A2, "YM")53 The ISPMT function calculates the interest paid during a particular period of an investment. Learn more. Financial MDURATION DATEDIF(A1, A2, "YM")54 Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more Financial MIRR DATEDIF(A1, A2, "YM")55 Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more Financial NOMINAL DATEDIF(A1, A2, "YM")56 Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more Financial NPER DATEDIF(A1, A2, "YM")57 Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial NPV DATEDIF(A1, A2, "YM")58 Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more Financial PDURATION DATEDIF(A1, A2, "YM")59 Returns the number of periods for an investment to reach a specific value at a given rate. Learn more. Financial PMT DATEDIF(A1, A2, "YM")60 Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial PPMT DATEDIF(A1, A2, "YM")61 Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial PRICE DATEDIF(A1, A2, "YM")62 Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more Financial PRICEDISC DATEDIF(A1, A2, "YM")63 Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more Financial PRICEMAT DATEDIF(A1, A2, "YM")64 Calculates the price of a security paying interest at maturity, based on expected yield. Learn more Financial PV DATEDIF(A1, A2, "YM")65 Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more Financial RATE DATEDIF(A1, A2, "YM")66 Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more Financial RECEIVED DATEDIF(A1, A2, "YM")67 Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more Financial RRI DATEDIF(A1, A2, "YM")68 Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more. Financial SLN DATEDIF(A1, A2, "YM")69 Calculates the depreciation of an asset for one period using the straight-line method. Learn more Financial SYD DATEDIF(A1, A2, "YM")70 Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more Financial TBILLEQ DATEDIF(A1, A2, "YM")71 Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more Financial TBILLPRICE DATEDIF(A1, A2, "YM")72 Calculates the price of a US Treasury Bill based on discount rate. Learn more Financial TBILLYIELD DATEDIF(A1, A2, "YM")73 Calculates the yield of a US Treasury Bill based on price. Learn more Financial VDB DATEDIF(A1, A2, "YM")74 Returns the depreciation of an asset for a particular period (or partial period). Learn more. Financial XIRR DATEDIF(A1, A2, "YM")75 Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more Financial XNPV DATEDIF(A1, A2, "YM")76 Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more Financial YIELD DATEDIF(A1, A2, "YM")77 Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more Financial YIELDDISC DATEDIF(A1, A2, "YM")78 Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more Financial YIELDMAT DATEDIF(A1, A2, "YM")79 Calculates the annual yield of a security paying interest at maturity, based on price. Learn more Google ARRAYFORMULA DATEDIF(A1, A2, "YM")80 Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more Google DETECTLANGUAGE DATEDIF(A1, A2, "YM")81 Identifies the language used in text within the specified range. Learn more Google GOOGLEFINANCE DATEDIF(A1, A2, "YM")82 Fetches current or historical securities information from Google Finance. Learn more Google GOOGLETRANSLATE DATEDIF(A1, A2, "YM")83 Translates text from one language into another Learn more Google IMAGE DATEDIF(A1, A2, "YM")84 Inserts an image into a cell. Learn more Google QUERY DATEDIF(A1, A2, "YM")85 Runs a Google Visualization API Query Language query across data. Learn more Google SPARKLINE DATEDIF(A1, A2, "YM")86 Creates a miniature chart contained within a single cell. Learn more Info ERROR.TYPE DATEDIF(A1, A2, "YM")87 Returns a number corresponding to the error value in a different cell. Learn more Info ISBLANK DATEDIF(A1, A2, "YM")88 Checks whether the referenced cell is empty. Learn more Info ISDATE DATEDIF(A1, A2, "YM")89 Returns whether a value is a date. Learn more. Info ISEMAIL DATEDIF(A1, A2, "YM")90 Checks whether a value is a valid email address. Learn more Info ISERR DATEDIF(A1, A2, "YM")91 Checks whether a value is an error other than `#N/A`. Learn more Info ISERROR DATEDIF(A1, A2, "YM")92 Checks whether a value is an error. Learn more Info ISFORMULA DATEDIF(A1, A2, "YM")93 Checks whether a formula is in the referenced cell. Learn more Info ISLOGICAL DATEDIF(A1, A2, "YM")94 Checks whether a value is `TRUE` or `FALSE`. Learn more Info ISNA DATEDIF(A1, A2, "YM")95 Checks whether a value is the error `#N/A`. Learn more Info ISNONTEXT DATEDIF(A1, A2, "YM")96 Checks whether a value is non-textual. Learn more Info ISNUMBER DATEDIF(A1, A2, "YM")97 Checks whether a value is a number. Learn more Info ISREF DATEDIF(A1, A2, "YM")98 Checks whether a value is a valid cell reference. Learn more Info ISTEXT DATEDIF(A1, A2, "YM")99 Checks whether a value is text. Learn more Info N DATEDIF("7/16/1969", "7/24/1969", "Y")00 Returns the argument provided as a number. Learn more Info NA DATEDIF("7/16/1969", "7/24/1969", "Y")01 Returns the "value not available" error, `#N/A`. Learn more Info TYPE DATEDIF("7/16/1969", "7/24/1969", "Y")02 Returns a number associated with the type of data passed into the function. Learn more Info CELL DATEDIF("7/16/1969", "7/24/1969", "Y")03 Returns the requested information about the specified cell. Learn more Logical AND DATEDIF("7/16/1969", "7/24/1969", "Y")04 Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more Logical FALSE DATEDIF("7/16/1969", "7/24/1969", "Y")05 Returns the logical value `FALSE`. Learn more Logical IF DATEDIF("7/16/1969", "7/24/1969", "Y")06 Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more Logical IFERROR DATEDIF("7/16/1969", "7/24/1969", "Y")07 Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more Logical IFNA DATEDIF("7/16/1969", "7/24/1969", "Y")08 Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more. Logical IFS DATEDIF("7/16/1969", "7/24/1969", "Y")09 Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more. Logical LAMBDA DATEDIF("7/16/1969", "7/24/1969", "Y")10 Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more Logical NOT DATEDIF("7/16/1969", "7/24/1969", "Y")11 Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more Logical OR DATEDIF("7/16/1969", "7/24/1969", "Y")12 Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more Logical SWITCH DATEDIF("7/16/1969", "7/24/1969", "Y")13 Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more Logical TRUE DATEDIF("7/16/1969", "7/24/1969", "Y")14 Returns the logical value `TRUE`. Learn more Logical XOR DATEDIF("7/16/1969", "7/24/1969", "Y")15 The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more. Lookup ADDRESS DATEDIF("7/16/1969", "7/24/1969", "Y")16 Returns a cell reference as a string. Learn more Lookup CHOOSE DATEDIF("7/16/1969", "7/24/1969", "Y")17 Returns an element from a list of choices based on index. Learn more Lookup COLUMN DATEDIF("7/16/1969", "7/24/1969", "Y")18 Returns the column number of a specified cell, with `A=1`. Learn more Lookup COLUMNS DATEDIF("7/16/1969", "7/24/1969", "Y")19 Returns the number of columns in a specified array or range. Learn more Lookup FORMULATEXT DATEDIF("7/16/1969", "7/24/1969", "Y")20 Returns the formula as a string. Learn more. Lookup GETPIVOTDATA DATEDIF("7/16/1969", "7/24/1969", "Y")21 Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more Lookup HLOOKUP DATEDIF("7/16/1969", "7/24/1969", "Y")22 Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more Lookup INDEX DATEDIF("7/16/1969", "7/24/1969", "Y")23 Returns the content of a cell, specified by row and column offset. Learn more Lookup INDIRECT DATEDIF("7/16/1969", "7/24/1969", "Y")24 Returns a cell reference specified by a string. Learn more Lookup LOOKUP DATEDIF("7/16/1969", "7/24/1969", "Y")25 Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more Lookup MATCH DATEDIF("7/16/1969", "7/24/1969", "Y")26 Returns the relative position of an item in a range that matches a specified value. Learn more Lookup OFFSET DATEDIF("7/16/1969", "7/24/1969", "Y")27 Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more Lookup ROW DATEDIF("7/16/1969", "7/24/1969", "Y")28 Returns the row number of a specified cell. Learn more Lookup ROWS DATEDIF("7/16/1969", "7/24/1969", "Y")29 Returns the number of rows in a specified array or range. Learn more Lookup VLOOKUP DATEDIF("7/16/1969", "7/24/1969", "Y")30 Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more Lookup XLOOKUP DATEDIF("7/16/1969", "7/24/1969", "Y")31 Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. Learn more Math ABS DATEDIF("7/16/1969", "7/24/1969", "Y")32 Returns the absolute value of a number. Learn more Math ACOS DATEDIF("7/16/1969", "7/24/1969", "Y")33 Returns the inverse cosine of a value, in radians. Learn more Math ACOSH DATEDIF("7/16/1969", "7/24/1969", "Y")34 Returns the inverse hyperbolic cosine of a number. Learn more Math ACOT DATEDIF("7/16/1969", "7/24/1969", "Y")35 Returns the inverse cotangent of a value, in radians. Learn more. Math ACOTH DATEDIF("7/16/1969", "7/24/1969", "Y")36 Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more. Math ASIN DATEDIF("7/16/1969", "7/24/1969", "Y")37 Returns the inverse sine of a value, in radians. Learn more Math ASINH DATEDIF("7/16/1969", "7/24/1969", "Y")38 Returns the inverse hyperbolic sine of a number. Learn more Math ATAN DATEDIF("7/16/1969", "7/24/1969", "Y")39 Returns the inverse tangent of a value, in radians. Learn more Math ATAN2 DATEDIF("7/16/1969", "7/24/1969", "Y")40 Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more Math ATANH DATEDIF("7/16/1969", "7/24/1969", "Y")41 Returns the inverse hyperbolic tangent of a number. Learn more Math BASE DATEDIF("7/16/1969", "7/24/1969", "Y")42 Converts a number into a text representation in another base, for example, base 2 for binary. Learn more. Math CEILING DATEDIF("7/16/1969", "7/24/1969", "Y")43 Rounds a number up to the nearest integer multiple of specified significance. Learn more Math CEILING.MATH DATEDIF("7/16/1969", "7/24/1969", "Y")44 Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. Math CEILING.PRECISE DATEDIF("7/16/1969", "7/24/1969", "Y")45 Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. Math COMBIN DATEDIF("7/16/1969", "7/24/1969", "Y")46 Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more Math COMBINA DATEDIF("7/16/1969", "7/24/1969", "Y")47 Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. Learn more. Math COS DATEDIF("7/16/1969", "7/24/1969", "Y")48 Returns the cosine of an angle provided in radians. Learn more Math COSH DATEDIF("7/16/1969", "7/24/1969", "Y")49 Returns the hyperbolic cosine of any real number. Learn more Math COT DATEDIF("7/16/1969", "7/24/1969", "Y")50 Cotangent of an angle provided in radians. Learn more. Math COTH DATEDIF("7/16/1969", "7/24/1969", "Y")51 Returns the hyperbolic cotangent of any real number. Learn more. Math COUNTBLANK DATEDIF("7/16/1969", "7/24/1969", "Y")52 Returns the number of empty cells in a given range. Learn more Math COUNTIF DATEDIF("7/16/1969", "7/24/1969", "Y")53 Returns a conditional count across a range. Learn more Math COUNTIFS DATEDIF("7/16/1969", "7/24/1969", "Y")54 Returns the count of a range depending on multiple criteria. Learn more Math COUNTUNIQUE DATEDIF("7/16/1969", "7/24/1969", "Y")55 Counts the number of unique values in a list of specified values and ranges. Learn more Math CSC DATEDIF("7/16/1969", "7/24/1969", "Y")56 Returns the cosecant of an angle provided in radians. Learn more. Math CSCH DATEDIF("7/16/1969", "7/24/1969", "Y")57 The CSCH function returns the hyperbolic cosecant of any real number. Learn more. Math DECIMAL DATEDIF("7/16/1969", "7/24/1969", "Y")58 The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more. Math DEGREES DATEDIF("7/16/1969", "7/24/1969", "Y")59 Converts an angle value in radians to degrees. Learn more Math ERFC DATEDIF("7/16/1969", "7/24/1969", "Y")60 Returns the complementary Gauss error function of a value. Learn more Math ERFC.PRECISE DATEDIF("7/16/1969", "7/24/1969", "Y")61 See ERFC Math EVEN DATEDIF("7/16/1969", "7/24/1969", "Y")62 Rounds a number up to the nearest even integer. Learn more Math EXP DATEDIF("7/16/1969", "7/24/1969", "Y")63 Returns Euler's number, e (~2.718) raised to a power. Learn more Math FACT DATEDIF("7/16/1969", "7/24/1969", "Y")64 Returns the factorial of a number. Learn more Math FACTDOUBLE DATEDIF("7/16/1969", "7/24/1969", "Y")65 Returns the "double factorial" of a number. Learn more Math FLOOR DATEDIF("7/16/1969", "7/24/1969", "Y")66 Rounds a number down to the nearest integer multiple of specified significance. Learn more Math FLOOR.MATH DATEDIF("7/16/1969", "7/24/1969", "Y")67 Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. Math FLOOR.PRECISE DATEDIF("7/16/1969", "7/24/1969", "Y")68 The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more. Math GAMMALN DATEDIF("7/16/1969", "7/24/1969", "Y")69 Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more Math GAMMALN.PRECISE DATEDIF("7/16/1969", "7/24/1969", "Y")70 See GAMMALN Math GCD DATEDIF("7/16/1969", "7/24/1969", "Y")71 Returns the greatest common divisor of one or more integers. Learn more Math IMLN DATEDIF("7/16/1969", "7/24/1969", "Y")72 Returns the logarithm of a complex number, base e (Euler's number). Learn more Math IMPOWER DATEDIF("7/16/1969", "7/24/1969", "Y")73 Returns a complex number raised to a power. Learn more Math IMSQRT DATEDIF("7/16/1969", "7/24/1969", "Y")74 Computes the square root of a complex number. Learn more Math INT DATEDIF("7/16/1969", "7/24/1969", "Y")75 Rounds a number down to the nearest integer that is less than or equal to it. Learn more Math ISEVEN DATEDIF("7/16/1969", "7/24/1969", "Y")76 Checks whether the provided value is even. Learn more Math ISO.CEILING DATEDIF("7/16/1969", "7/24/1969", "Y")77 See CEILING.PRECISE Math ISODD DATEDIF("7/16/1969", "7/24/1969", "Y")78 Checks whether the provided value is odd. Learn more Math LCM DATEDIF("7/16/1969", "7/24/1969", "Y")79 Returns the least common multiple of one or more integers. Learn more Math LN DATEDIF("7/16/1969", "7/24/1969", "Y")80 Returns the the logarithm of a number, base e (Euler's number). Learn more Math LOG DATEDIF("7/16/1969", "7/24/1969", "Y")81 Returns the the logarithm of a number given a base. Learn more Math LOG10 DATEDIF("7/16/1969", "7/24/1969", "Y")82 Returns the the logarithm of a number, base 10. Learn more Math MOD DATEDIF("7/16/1969", "7/24/1969", "Y")83 Returns the result of the modulo operator, the remainder after a division operation. Learn more Math MROUND DATEDIF("7/16/1969", "7/24/1969", "Y")84 Rounds one number to the nearest integer multiple of another. Learn more Math MULTINOMIAL DATEDIF("7/16/1969", "7/24/1969", "Y")85 Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more Math MUNIT DATEDIF("7/16/1969", "7/24/1969", "Y")86 Returns a unit matrix of size dimension x dimension. Learn more. Math ODD DATEDIF("7/16/1969", "7/24/1969", "Y")87 Rounds a number up to the nearest odd integer. Learn more Math PI DATEDIF("7/16/1969", "7/24/1969", "Y")88 Returns the value of Pi to 14 decimal places. Learn more Math POWER DATEDIF("7/16/1969", "7/24/1969", "Y")89 Returns a number raised to a power. Learn more Math PRODUCT DATEDIF("7/16/1969", "7/24/1969", "Y")90 Returns the result of multiplying a series of numbers together. Learn more Math QUOTIENT DATEDIF("7/16/1969", "7/24/1969", "Y")91 Returns one number divided by another. Learn more Math RADIANS DATEDIF("7/16/1969", "7/24/1969", "Y")92 Converts an angle value in degrees to radians. Learn more Math RAND DATEDIF("7/16/1969", "7/24/1969", "Y")93 Returns a random number between 0 inclusive and 1 exclusive. Learn more Math RANDARRAY DATEDIF("7/16/1969", "7/24/1969", "Y")94 Generates an array of random numbers between 0 and 1. Learn more. Math RANDBETWEEN DATEDIF("7/16/1969", "7/24/1969", "Y")95 Returns a uniformly random integer between two values, inclusive. Learn more Math ROUND DATEDIF("7/16/1969", "7/24/1969", "Y")96 Rounds a number to a certain number of decimal places according to standard rules. Learn more Math ROUNDDOWN DATEDIF("7/16/1969", "7/24/1969", "Y")97 Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more Math ROUNDUP DATEDIF("7/16/1969", "7/24/1969", "Y")98 Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more Math SEC DATEDIF("7/16/1969", "7/24/1969", "Y")99 The SEC function returns the secant of an angle, measured in radians. Learn more. Math SECH DATEDIF(start_date, end_date, unit)00 The SECH function returns the hyperbolic secant of an angle. Learn more Math SEQUENCE DATEDIF(start_date, end_date, unit)01 Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more. Math SERIESSUM DATEDIF(start_date, end_date, unit)02 Given parameters DATEDIF(start_date, end_date, unit)03, DATEDIF(start_date, end_date, unit)04, DATEDIF(start_date, end_date, unit)05, and DATEDIF(start_date, end_date, unit)06, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more Math SIGN DATEDIF(start_date, end_date, unit)07 Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more Math SIN DATEDIF(start_date, end_date, unit)08 Returns the sine of an angle provided in radians. Learn more Math SINH DATEDIF(start_date, end_date, unit)09 Returns the hyperbolic sine of any real number. Learn more Math SQRT DATEDIF(start_date, end_date, unit)10 Returns the positive square root of a positive number. Learn more Math SQRTPI DATEDIF(start_date, end_date, unit)11 Returns the positive square root of the product of Pi and the given positive number. Learn more Math SUBTOTAL DATEDIF(start_date, end_date, unit)12 Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more Math SUM DATEDIF(start_date, end_date, unit)13 Returns the sum of a series of numbers and/or cells. Learn more Math SUMIF DATEDIF(start_date, end_date, unit)14 Returns a conditional sum across a range. Learn more Math SUMIFS DATEDIF(start_date, end_date, unit)15 Returns the sum of a range depending on multiple criteria. Learn more Math SUMSQ DATEDIF(start_date, end_date, unit)16 Returns the sum of the squares of a series of numbers and/or cells. Learn more Math TAN DATEDIF(start_date, end_date, unit)17 Returns the tangent of an angle provided in radians. Learn more Math TANH DATEDIF(start_date, end_date, unit)18 Returns the hyperbolic tangent of any real number. Learn more Math TRUNC DATEDIF(start_date, end_date, unit)19 Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more Operator ADD DATEDIF(start_date, end_date, unit)20 Returns the sum of two numbers. Equivalent to the `+` operator. Learn more Operator CONCAT DATEDIF(start_date, end_date, unit)21 Returns the concatenation of two values. Equivalent to the `&` operator. Learn more Operator DIVIDE DATEDIF(start_date, end_date, unit)22 Returns one number divided by another. Equivalent to the `/` operator. Learn more Operator EQ DATEDIF(start_date, end_date, unit)23 Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more Operator GT DATEDIF(start_date, end_date, unit)24 Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more Operator GTE DATEDIF(start_date, end_date, unit)25 Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more Operator ISBETWEEN DATEDIF(start_date, end_date, unit)26 Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more Operator LT DATEDIF(start_date, end_date, unit)27 Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more Operator LTE DATEDIF(start_date, end_date, unit)28 Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more Operator MINUS DATEDIF(start_date, end_date, unit)29 Returns the difference of two numbers. Equivalent to the `-` operator. Learn more Operator MULTIPLY DATEDIF(start_date, end_date, unit)30 Returns the product of two numbers. Equivalent to the `*` operator. Learn more Operator NE DATEDIF(start_date, end_date, unit)31 Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more Operator POW DATEDIF(start_date, end_date, unit)32 Returns a number raised to a power. Learn more Operator UMINUS DATEDIF(start_date, end_date, unit)33 Returns a number with the sign reversed. Learn more Operator UNARY_PERCENT DATEDIF(start_date, end_date, unit)34 Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more Operator UNIQUE DATEDIF(start_date, end_date, unit)35 Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more Operator UPLUS DATEDIF(start_date, end_date, unit)36 Returns a specified number, unchanged. Learn more Statistical AVEDEV DATEDIF(start_date, end_date, unit)37 Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more Statistical AVERAGE DATEDIF(start_date, end_date, unit)38 Returns the numerical average value in a dataset, ignoring text. Learn more Statistical AVERAGE.WEIGHTED DATEDIF(start_date, end_date, unit)39 Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more. Statistical AVERAGEA DATEDIF(start_date, end_date, unit)40 Returns the numerical average value in a dataset. Learn more Statistical AVERAGEIF DATEDIF(start_date, end_date, unit)41 Returns the average of a range depending on criteria. Learn more Statistical AVERAGEIFS DATEDIF(start_date, end_date, unit)42 Returns the average of a range depending on multiple criteria. Learn more Statistical BETA.DIST DATEDIF(start_date, end_date, unit)43 Returns the probability of a given value as defined by the beta distribution function. Learn more. Statistical BETA.INV DATEDIF(start_date, end_date, unit)44 Returns the value of the inverse beta distribution function for a given probability. Learn more. Statistical BETADIST DATEDIF(start_date, end_date, unit)45 See BETA.DIST. Statistical BETAINV DATEDIF(start_date, end_date, unit)46 See BETA.INV Statistical BINOM.DIST DATEDIF(start_date, end_date, unit)47 See BINOMDIST Statistical BINOM.INV DATEDIF(start_date, end_date, unit)48 See CRITBINOM Statistical BINOMDIST DATEDIF(start_date, end_date, unit)49 Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more Statistical CHIDIST DATEDIF(start_date, end_date, unit)50 Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more Statistical CHIINV DATEDIF(start_date, end_date, unit)51 Calculates the inverse of the right-tailed chi-squared distribution. Learn more Statistical CHISQ.DIST DATEDIF(start_date, end_date, unit)52 Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more Statistical CHISQ.DIST.RT DATEDIF(start_date, end_date, unit)53 Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more Statistical CHISQ.INV DATEDIF(start_date, end_date, unit)54 Calculates the inverse of the left-tailed chi-squared distribution. Learn more Statistical CHISQ.INV.RT DATEDIF(start_date, end_date, unit)55 Calculates the inverse of the right-tailed chi-squared distribution. Learn more Statistical CHISQ.TEST DATEDIF(start_date, end_date, unit)56 See CHITEST Statistical CHITEST DATEDIF(start_date, end_date, unit)57 Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more Statistical CONFIDENCE DATEDIF(start_date, end_date, unit)58 See CONFIDENCE.NORM Statistical CONFIDENCE.NORM DATEDIF(start_date, end_date, unit)59 Calculates the width of half the confidence interval for a normal distribution. Learn more. Statistical CONFIDENCE.T DATEDIF(start_date, end_date, unit)60 Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more. Statistical CORREL DATEDIF(start_date, end_date, unit)61 Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more Statistical COUNT DATEDIF(start_date, end_date, unit)62 Returns a count of the number of numeric values in a dataset. Learn more Statistical COUNTA DATEDIF(start_date, end_date, unit)63 Returns a count of the number of values in a dataset. Learn more Statistical COVAR DATEDIF(start_date, end_date, unit)64 Calculates the covariance of a dataset. Learn more Statistical COVARIANCE.P DATEDIF(start_date, end_date, unit)65 See COVAR Statistical COVARIANCE.S DATEDIF(start_date, end_date, unit)66 Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more. Statistical CRITBINOM DATEDIF(start_date, end_date, unit)67 Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more Statistical DEVSQ DATEDIF(start_date, end_date, unit)68 Calculates the sum of squares of deviations based on a sample. Learn more Statistical EXPON.DIST DATEDIF(start_date, end_date, unit)69 Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more. Statistical EXPONDIST DATEDIF(start_date, end_date, unit)70 See EXPON.DIST Statistical F.DIST DATEDIF(start_date, end_date, unit)71 Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more Statistical F.DIST.RT DATEDIF(start_date, end_date, unit)72 Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more Statistical F.INV DATEDIF(start_date, end_date, unit)73 Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more Statistical F.INV.RT DATEDIF(start_date, end_date, unit)74 Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more Statistical F.TEST DATEDIF(start_date, end_date, unit)75 See FTEST. Statistical FDIST DATEDIF(start_date, end_date, unit)76 See F.DIST.RT. Statistical FINV DATEDIF(start_date, end_date, unit)77 See F.INV.RT Statistical FISHER DATEDIF(start_date, end_date, unit)78 Returns the Fisher transformation of a specified value. Learn more Statistical FISHERINV DATEDIF(start_date, end_date, unit)79 Returns the inverse Fisher transformation of a specified value. Learn more Statistical FORECAST DATEDIF(start_date, end_date, unit)80 Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more Statistical FORECAST.LINEAR DATEDIF(start_date, end_date, unit)81 See FORECAST Statistical FTEST DATEDIF(start_date, end_date, unit)82 Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more Statistical GAMMA DATEDIF(start_date, end_date, unit)83 Returns the Gamma function evaluated at the specified value. Learn more. Statistical GAMMA.DIST DATEDIF(start_date, end_date, unit)84 Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more Statistical GAMMA.INV DATEDIF(start_date, end_date, unit)85 The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more. Statistical GAMMADIST DATEDIF(start_date, end_date, unit)86 See GAMMA.DIST Statistical GAMMAINV DATEDIF(start_date, end_date, unit)87 See GAMMA.INV. Statistical GAUSS DATEDIF(start_date, end_date, unit)88 The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more. Statistical GEOMEAN DATEDIF(start_date, end_date, unit)89 Calculates the geometric mean of a dataset. Learn more Statistical HARMEAN DATEDIF(start_date, end_date, unit)90 Calculates the harmonic mean of a dataset. Learn more Statistical HYPGEOM.DIST DATEDIF(start_date, end_date, unit)91 See HYPGEOMDIST Statistical HYPGEOMDIST DATEDIF(start_date, end_date, unit)92 Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws. Learn more Statistical INTERCEPT DATEDIF(start_date, end_date, unit)93 Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more Statistical KURT DATEDIF(start_date, end_date, unit)94 Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more Statistical LARGE DATEDIF(start_date, end_date, unit)95 Returns the nth largest element from a data set, where n is user-defined. Learn more Statistical LOGINV DATEDIF(start_date, end_date, unit)96 Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more Statistical LOGNORM.DIST DATEDIF(start_date, end_date, unit)97 See LOGNORMDIST Statistical LOGNORM.INV DATEDIF(start_date, end_date, unit)98 See LOGINV Statistical LOGNORMDIST DATEDIF(start_date, end_date, unit)99 Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more Statistical MAX start_date00 Returns the maximum value in a numeric dataset. Learn more Statistical MAXA start_date01 Returns the maximum numeric value in a dataset. Learn more Statistical MAXIFS start_date02 Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more. Statistical MEDIAN start_date03 Returns the median value in a numeric dataset. Learn more Statistical MIN start_date04 Returns the minimum value in a numeric dataset. Learn more Statistical MINA start_date05 Returns the minimum numeric value in a dataset. Learn more Statistical MINIFS start_date06 Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more. Statistical MODE start_date07 Returns the most commonly occurring value in a dataset. Learn more Statistical MODE.MULT start_date08 Returns the most commonly occurring values in a dataset. Learn more. Statistical MODE.SNGL start_date09 See MODE Statistical NEGBINOM.DIST start_date10 See NEGBINOMDIST Statistical NEGBINOMDIST start_date11 Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more Statistical NORM.DIST start_date12 See NORMDIST Statistical NORM.INV start_date13 See NORMINV Statistical NORM.S.DIST start_date14 See NORMSDIST Statistical NORM.S.INV start_date15 See NORMSINV Statistical NORMDIST start_date16 Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. Learn more Statistical NORMINV start_date17 Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more Statistical NORMSDIST start_date18 Returns the value of the standard normal cumulative distribution function for a specified value. Learn more Statistical NORMSINV start_date19 Returns the value of the inverse standard normal distribution function for a specified value. Learn more Statistical PEARSON start_date20 Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more Statistical PERCENTILE start_date21 Returns the value at a given percentile of a dataset. Learn more Statistical PERCENTILE.EXC start_date22 Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more. Statistical PERCENTILE.INC start_date23 See PERCENTILE Statistical PERCENTRANK start_date24 Returns the percentage rank (percentile) of a specified value in a dataset. Learn more Statistical PERCENTRANK.EXC start_date25 Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more Statistical PERCENTRANK.INC start_date26 Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Learn more Statistical PERMUTATIONA start_date27 Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more. Statistical PERMUT start_date28 Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more Statistical PHI start_date29 The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more. Statistical POISSON start_date30 See POISSON.DIST Statistical POISSON.DIST start_date31 Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more. Statistical PROB start_date32 Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more Statistical QUARTILE start_date33 Returns a value nearest to a specified quartile of a dataset. Learn more Statistical QUARTILE.EXC start_date34 Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more. Statistical QUARTILE.INC start_date35 See QUARTILE Statistical RANK start_date36 Returns the rank of a specified value in a dataset. Learn more Statistical RANK.AVG start_date37 Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more Statistical RANK.EQ start_date38 Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more Statistical RSQ start_date39 Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more Statistical SKEW start_date40 Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more Statistical SKEW.P start_date41 Calculates the skewness of a dataset that represents the entire population. Learn more. Statistical SLOPE start_date42 Calculates the slope of the line resulting from linear regression of a dataset. Learn more Statistical SMALL start_date43 Returns the nth smallest element from a data set, where n is user-defined. Learn more Statistical STANDARDIZE start_date44 Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more Statistical STDEV start_date45 Calculates the standard deviation based on a sample. Learn more Statistical STDEV.P start_date46 See STDEVP Statistical STDEV.S start_date47 See STDEV Statistical STDEVA start_date48 Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more Statistical STDEVP start_date49 Calculates the standard deviation based on an entire population. Learn more Statistical STDEVPA start_date50 Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more Statistical STEYX start_date51 Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more Statistical T.DIST start_date52 Returns the right tailed Student distribution for a value x. Learn more. Statistical T.DIST.2T start_date53 Returns the two tailed Student distribution for a value x. Learn more. Statistical T.DIST.RT start_date54 Returns the right tailed Student distribution for a value x. Learn more. Statistical T.INV start_date55 Calculates the negative inverse of the one-tailed TDIST function. Learn more Statistical T.INV.2T start_date56 Calculates the inverse of the two-tailed TDIST function. Learn more Statistical T.TEST start_date57 Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more. Statistical TDIST start_date58 Calculates the probability for Student's t-distribution with a given input (x). Learn more Statistical TINV start_date59 See T.INV.2T Statistical TRIMMEAN start_date60 Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more Statistical TTEST start_date61 See T.TEST. Statistical VAR start_date62 Calculates the variance based on a sample. Learn more Statistical VAR.P start_date63 See VARP Statistical VAR.S start_date64 See VAR Statistical VARA start_date65 Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more Statistical VARP start_date66 Calculates the variance based on an entire population. Learn more Statistical VARPA start_date67 Calculates the variance based on an entire population, setting text to the value `0`. Learn more Statistical WEIBULL start_date68 Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more Statistical WEIBULL.DIST start_date69 See WEIBULL Statistical Z.TEST start_date70 Returns the one-tailed P-value of a Z-test with standard distribution. Learn more. Statistical ZTEST start_date71 See Z.TEST. Text ARABIC start_date72 Computes the value of a Roman numeral. Learn more Text ASC start_date73 Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more. Text CHAR start_date74 Convert a number into a character according to the current Unicode table. Learn more Text CLEAN start_date75 Returns the text with the non-printable ASCII characters removed. Learn more Text CODE start_date76 Returns the numeric Unicode map value of the first character in the string provided. Learn more Text CONCATENATE start_date77 Appends strings to one another. Learn more Text DOLLAR start_date78 Formats a number into the locale-specific currency format. Learn more Text EXACT start_date79 Tests whether two strings are identical. Learn more Text FIND start_date80 Returns the position at which a string is first found within text. Learn more Text FINDB start_date81 Returns the position at which a string is first found within text counting each double-character as 2. Learn more Text FIXED start_date82 Formats a number with a fixed number of decimal places. Learn more Text JOIN start_date83 Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more Text LEFT start_date84 Returns a substring from the beginning of a specified string. Learn more Text LEFTB start_date85 Returns the left portion of a string up to a certain number of bytes. Learn more. Text LEN start_date86 Returns the length of a string. Learn more Text LENB start_date87 Returns the length of a string in bytes." Learn more. Text LOWER start_date88 Converts a specified string to lowercase. Learn more Text MID start_date89 Returns a segment of a string. Learn more Text MIDB start_date90 Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more. Text PROPER start_date91 Capitalizes each word in a specified string. Learn more Text REGEXEXTRACT start_date92 Extracts matching substrings according to a regular expression. Learn more Text REGEXMATCH start_date93 Whether a piece of text matches a regular expression. Learn more Text REGEXREPLACE start_date94 Replaces part of a text string with a different text string using regular expressions. Learn more Text REPLACE start_date95 Replaces part of a text string with a different text string. Learn more Text REPLACEB start_date96 Replaces part of a text string, based on a number of bytes, with a different text string. Learn more. Text REPT start_date97 Returns specified text repeated a number of times. Learn more Text RIGHT start_date98 Returns a substring from the end of a specified string. Learn more Text RIGHTB start_date99 Returns the right portion of a string up to a certain number of bytes. Learn more. Text ROMAN DATE00 Formats a number in Roman numerals. Learn more Text SEARCH DATE01 Returns the position at which a string is first found within text. Learn more Text SEARCHB DATE02 Returns the position at which a string is first found within text counting each double-character as 2. Learn more Text SPLIT DATE03 Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more Text SUBSTITUTE DATE04 Replaces existing text with new text in a string. Learn more Text T DATE05 Returns string arguments as text. Learn more Text TEXT DATE06 Converts a number into text according to a specified format. Learn more Text TEXTJOIN DATE07 Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more. Text TRIM DATE08 Removes leading and trailing spaces in a specified string. Learn more Text UNICHAR DATE09 Returns the Unicode character for a number. Learn more. Text UNICODE DATE10 Returns the decimal Unicode value of the first character of the text. Learn more. Text UPPER DATE11 Converts a specified string to uppercase. Learn more Text VALUE DATE12 Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more Database DAVERAGE DATE13 Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more Database DCOUNT DATE14 Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more Database DCOUNTA DATE15 Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more Database DGET DATE16 Returns a single value from a database table-like array or range using a SQL-like query. Learn more Database DMAX DATE17 Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more Database DMIN DATE18 Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more Database DPRODUCT DATE19 Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more Database DSTDEV DATE20 Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more Database DSTDEVP DATE21 Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more Database DSUM DATE22 Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more Database DVAR DATE23 Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more Database DVARP DATE24 Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more Parser CONVERT DATE25 Converts a numeric value to a different unit of measure. Learn more Parser TO_DATE DATE26 Converts a provided number to a date. Learn more Parser TO_DOLLARS DATE27 Converts a provided number to a dollar value. Learn more Parser TO_PERCENT DATE28 Converts a provided number to a percentage. Learn more Parser TO_PURE_NUMBER DATE29 Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting. Learn more Parser TO_TEXT DATE30 Converts a provided numeric value to a text value. Learn more Array ARRAY_CONSTRAIN DATE31 Constrains an array result to a specified size. Learn more Array BYCOL DATE32 Groups an array by columns by application of a LAMBDA function to each column. Learn more Array BYROW DATE33 Groups an array by rows by application of a LAMBDA function to each row. Learn more Array FLATTEN DATE34 Flattens all the values from one or more ranges into a single column. Learn more Array FREQUENCY DATE35 Calculates the frequency distribution of a one-column array into specified classes. Learn more Array GROWTH DATE36 Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more Array LINEST DATE37 Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more Array LOGEST DATE38 Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more Array MAKEARRAY DATE39 Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more Array MAP DATE40 Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. Learn more Array MDETERM DATE41 Returns the matrix determinant of a square matrix specified as an array or range. Learn more Array MINVERSE DATE42 Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more Array MMULT DATE43 Calculates the matrix product of two matrices specified as arrays or ranges. Learn more Array REDUCE DATE44 Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn more Array SCAN DATE45 Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step. Learn more Array SUMPRODUCT DATE46 Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more Array SUMX2MY2 DATE47 Calculates the sum of the differences of the squares of values in two arrays. Learn more Array SUMX2PY2 DATE48 Calculates the sum of the sums of the squares of values in two arrays. Learn more Array SUMXMY2 DATE49 Calculates the sum of the squares of differences of values in two arrays. Learn more Array TRANSPOSE DATE50 Transposes the rows and columns of an array or range of cells. Learn more Array TREND DATE51 Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more Web ENCODEURL DATE52 Encodes a string of text for the purpose of using in a URL query. Learn more. Web HYPERLINK DATE53 Creates a hyperlink inside a cell. Learn more Web IMPORTDATA DATE54 Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more Web IMPORTFEED DATE55 Imports a RSS or ATOM feed. Learn more Web IMPORTHTML DATE56 Imports data from a table or list within an HTML page. Learn more Web IMPORTRANGE DATE57 Imports a range of cells from a specified spreadsheet. Learn more Web IMPORTXML DATE58 Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more Web ISURL DATE59 Checks whether a value is a valid URL. Learn more

Hướng dẫn difference google sheets formula - công thức trang tính khác nhau của google

Sample Usage

Syntax

Notes

See Also

Examples

Number of days

Months

Bài Viết Liên Quan

Quảng Cáo

Có thể bạn quan tâm

Toplist được quan tâm

Quảng cáo

Xem Nhiều

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội