## IFERROR

Explanation IFERROR Excel function returns a custom error message in case of an Excel error. An Excel error can be one of the following: #N/A - Value not found #DIV/0…

## EOMONTH

Explanation EOMONTH allows us to return the date of the last day of a month, based on a specific date provided. For example, we can use EOMONTH to find out…

## WEEKDAY

Explanation WEEKDAY function returns the number of the day in the week - from 1 to 7. WEEKDAY Syntax =WEEKDAY(serial_number, [return_type]) serial_number - The date for which we want to…

## DATE

Explanation DATE function allows us to create a date from individual numbers which represent the day, month and year. Syntax =DATE(year,month,day) year - The value of the year  month -…

## DAY, MONTH, YEAR

Explanation DAY, MONTH, YEAR are used for extraction of the day, month and year part from an Excel date. Let's see how it works! Syntax To extract the day from…

## LOWER, UPPER, PROPER

Explanation LOWER, UPPER and PROPER are text functions which let us do the following: LOWER - Converts all words in the text to lowercase. UPPER - Converts all words in…

## TRIM

Explanation TRIM function is used for the removal of extra space characters.  When the excess spaces appear between two words, the function keeps only one space character. Example Notice the…

## SEARCH

Explanation SEARCH function lets us find the position of a text within another text/cell.  Note that FIND is case-insensitive. You can use it to lookup lowercase/uppercase letters - all combinations…

## FIND

Explanation FIND function lets us find the position of a text within another text/cell.  Note that FIND is case-sensitive, meaning that if you try to find "GOAT" within "goat cheese",…

## LEN

Explanation LEN function is used to discover the LENGTH of a cell - It allows us to know the number of characters in a certain cell. Let's see how it…

End of content