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 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 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 a date to a Julian date format in Excel, you can do so by building a formula that uses the TEXT, YEAR, and DATE functions.
Background
"Julian date format" refers to a format where the year value...

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 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...

If you want to use conditional formatting to highlight dates that are in the same month and year as another date, you can use a simple formula based on the TEXT function.
For example, if you have dates in the range B4:...

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 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 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...

If you need to get the month name (i.e. January, February, March, etc.) from a date, you have several options depending on your needs.
Do you just want to display the month name?
If you only want to display a month...

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...

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 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,"...

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...