To join a date with text, you can use concatenation with the TEXT function to control the date format. In the example shown, the formula in E4 is:
="The date is "&TEXT(B4,"dddd, mmmm yyyy")...

If you need to convert dates to text (i.e. date to string conversion) , you can use the TEXT function. The TEXT function can use patterns like "dd/mm/yyyy", "yyyy-mm-dd", etc. to convert a valid date to a text value....

To lookup the first entry in a table by month and year, you can use and array formula based on the INDEX, MATCH, and TEXT functions.
the LOOKUP function with the TEXT function. In the example shown, the formula in F5...

To add a date stamp in a workbook to indicate a "date last updated", you can use the TEXT function. In the example shown, the formula in C5 is:
="Last update: "& TEXT(B5, "ddd, mmmm d, yyyy")...

To convert numbers into text values, you can use the TEXT function.
In the example shown, the formula in C5 is:
=TEXT(B5,"0")
Background
Normally, you want to maintain numeric values in Excel, because...

To calculate and display the days, hours, and minutes between two dates, you can use the TEXT function with a little help from the INT function. In the example shown, the formula in D5 is:
=INT(C5-B5)&" days...

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 just want to display the day name?
If you only want to display a day name, you don't...

This formula looks at one way to increment a number that is embedded in a text string. The purpose of this example to show how multiple functions can be combined to split, manipulate, and rejoin values.
In the example...

To convert a normal Excel date into yyyymm format (e.g. 9/1/2017 > 201709), you can use the TEXT function.
In the example shown, the formula in C6 is:
=TEXT(B6,"yyyymm")
How this formula works
The TEXT...

To lookup the last entry in a table by month and year, you can use the LOOKUP function with the TEXT function. In the example shown, the formula in F5 is:
=LOOKUP(2,1/(TEXT($B$5:$B$13,"mmyy")=TEXT(E5,"...

To pad a number with zeros, you can use a simple formula based on the TEXT function. To pad with a variable number of zeros, you can add the REPT function.
In the example show, the formula in D6 is:
=TEXT(B6,"...

To pad week numbers (or any number) with zeros using a formula, you can use the TEXT function.
In the example show, D5 contains this formula:
=TEXT(WEEKNUM(B5,21),"00")
Which returns the string "07".
How...

To find the maximum value in a given month, you can use the MAXIFS function or one of the other alternatives below. In the example shown, the formula in G5 is:
=MAXIFS(sales,dates,">="&G4,dates,...

To display a date range in one cell based on dates in different cells, you can use a formula based on the TEXT function.
In the example shown, the formula in cell E5 is:
=TEXT(B5,"mmm d")&" -...

To perform a partial match (a substring match) against numbers, you can use an array formula based on MATCH and TEXT.
Background
Excel supports the wildcard characters "*" and "?". However, if you use wildcards with a...