Excel functions--date, Substitute, REPLACE, ISERROR, IFERROR

1. DATE

The date function returns a sequential sequence number that represents a specific date. For example, the formula

=date (2008,7,8)

Returns 2008-7-8 or 39637, depending on the format of the cell, but empty cells are calculated and the default date format is assumed.

DATE can also operate on numbers with only the latter two digits of the year, such as =date (90,1,1):

This will solve the problem of how to extract birthdays from 15-bit IDs.

2, substitute

Replace Old_text with new_text in a text string. If you need to replace the specified text in a text string, use the function substitute;

If you need to replace any text at the specified position in a text string, use the function Replace.

3. REPLACE

Replace uses a different text string and replaces some of the text in a text string based on the number of characters you specify.

REPLACEB uses a different text string and replaces some of the text in a text string based on the number of bytes specified.

4, ISERROR

The value is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!), returns TRUE

function	returns TRUE if it is:
isblank	The value is a blank cell.
iserr	The value is any error value (minus #N/a).
iserror	value is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!).
islogical	The value is a logical value.
isna	The value is the error value #N/A (the value does not exist).
isnontext	Value is any item that is not text (note that this function returns TRUE when the value is an empty cell).
isnumber	The value is a number.
isref	The value is a reference.
Istext	The value is text.

If you want to implement what you do when the value is wrong, you need to mate with the IF function.

Such as:

5, IFERROR

But this is not the time to do so, Excel takes into account the needs of everyone, with its own iferror function:

IFERROR (value, Value_if_error)

The IFERROR function syntax has the following parameters parameter: A value that provides information for an action, event, method, property, function, or procedure. ）：

• value is required. Check if there are any wrong arguments.
• Value_if_error required. The formula evaluates to an error when the value to return. The calculated error types are: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? Or #NULL!.

Excel functions--date, Substitute, REPLACE, ISERROR, IFERROR