The NETWORKDAYS function

Returns the number of whole workdays between two dates

Date and TimeMatthew Di MinnoMarch 19, 2020Comment

The MONTH function

Converts a serial number to a month

Date and TimeMatthew Di MinnoMarch 18, 2020Comment

The MODE.SNGL function

Returns the most common value in a data set

StatisticalMatthew Di MinnoMarch 17, 2020Comment

The MODE.MULT function

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

StatisticalMatthew Di MinnoMarch 16, 2020Comment

The MINUTE function

Converts a serial number to a minute

Date and TimeMatthew Di MinnoMarch 15, 2020Comment

The MIN function

Returns the minimum value in a list of arguments

StatisticalMatthew Di MinnoMarch 14, 2020Comment

The MID function

Returns a specific number of characters from a text string starting at the position you specify

TextMatthew Di MinnoMarch 13, 2020Comment

The MEDIAN function

Returns the median of the given numbers

StatisticalMatthew Di MinnoMarch 12, 2020Comment

The MAX function

Returns the maximum value in a list of arguments

StatisticalMatthew Di MinnoMarch 11, 2020Comment

The MATCH function

Looks up values in a reference or array

Lookup and referenceMatthew Di MinnoMarch 10, 2020Comment

The LOOKUP function

Looks up values in a vector or array

Lookup and referenceMatthew Di MinnoMarch 9, 2020Comment

The LEN function

Returns the number of characters in a text string

TextMatthew Di MinnoMarch 8, 2020Comment

The LEFT function

Returns the leftmost characters from a text value

TextMatthew Di MinnoMarch 7, 2020Comment

The LARGE function

Returns the k-th largest value in a data set

StatisticalMatthew Di MinnoMarch 6, 2020Comment

The INDEX function

Uses an index to choose a value from a reference or array

Lookup and referenceMatthew Di MinnoMarch 5, 2020Comment

The IFS function

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

LogicalMatthew Di MinnoMarch 4, 2020Comment

The IFERROR function

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

LogicalMatthew Di MinnoMarch 3, 2020Comment

The IF function

Specifies a logical test to perform

LogicalMatthew Di MinnoMarch 2, 2020Comment

The HOUR function

Converts a serial number to an hour

Date and TimeMatthew Di MinnoMarch 1, 2020Comment

The HLOOKUP function

Looks in the top row of an array and returns the value of the indicated cell

Lookup and referenceMatthew Di MinnoFebruary 29, 2020Comment