The TEXT function can apply number formatting to numbers just like Excel's built-in cell formats for dates, currency, fractions, and so on. However, unlike Excel's cell formatting, the TEXT function works inside a...

This formula builds the final result in 2 parts, joined by concatenation with the ampersand (...

The MAXIFS function can find the maximum value in a range based on one or more criteria. In the example shown, we are using MAXIFS to find the max sales value based in a given month by "bracketing" dates between the...

The TEXT function can apply number formats of any kind to numbers. It is most often used when you want to maintain number formatting for a number when concatenating that number with other text.
In this case, the TEXT...

The TEXT function takes numeric values and converts them to text values using the format you specify. In this example, we are using the format "mmm d" for both TEXT functions in E5. The results are joined with a hyphen...

The TEXT function accepts a number as the first argument, something called "format_text" as the second. The format_text argument works like a number format, and specifies the formatting that should be used when...

The TEXT function applies the number format you specify to a numeric value, and returns a result as text.
In this case, the number format provided is "yyyymm", which joins a 4-digit year with a 2-digit month value....

The TEXT function can apply number formats of any kind, including currency, date, percentage, etc. By applying a number format like "00", "000", "0000", you can "pad" numbers with as many zeros as you like. Zeros will...

This example is set up in two parts for clarity: (1) a formula to determine the top 3 amounts for each month and (2) a formula to retrieve the client name for each of the top 3 monthly amounts.
Note there is no actual...

Note: the lookup_value of 2 is deliberately larger than any values in the lookup_vector, following the concept of bignum.
Working from the inside out, the expression:
(TEXT($B$5:$B$13,"mmyy")=TEXT(E5,...

At the core, this formula extracts the number, adds the increment, and joins the number to the original text in the right format.
Working from the inside out, this formula first extracts the numeric portion of the...

Dates and times in Excel are stored as serial numbers and converted to human readable values on the fly using number formats. When you enter a date in Excel, you can apply a number format to display that date as you...

Most of the work in this formula is done by the TEXT function, which applies a custom number format for hours and minutes to a value created by subtracting the start date from the end date.
TEXT(C5-B5,"h"...

If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs.
Do you want to convert the date into a day name?
If you want to convert the date value to a...

Excel supports the wildcard characters "*" and "?", and these wildcards can be used to perform partial (substring) matches in various lookup formulas.
However, if you use wildcards together with a number, you'll...