Replace one or many instances of specific text based on its content (not on its position).

SUBSTITUTE(text, old_text, new_text, [instance_num])

Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

Return the year, month or day component of a date

=YEAR(serial_number), =MONTH(serial_number), =DAY(serial_number)

Returns a vertical array of the most common values in a data set.

=MODE.MULT(number1, [number2], ...)

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])

Return the serial number of the current date and time

=NOW()

Lookup values by column in a horizontal table or range

=HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])

Return a reference that is a specified number of rows and columns from a starting point

=OFFSET(reference, rows, cols, [height], [width])

Replace part of a text string based on its position with new text.

REPLACE(old_text, start_num, num_chars, new_text)

Return the relative position of a specified item in a range

=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Repeat a specific text string by a number of instances.

REPT(text, number_times)