My Own Quick Excel Formula Lookups

This will become my own page of quick Excel formulas that I find myself looking up elsewhere far too often! It should flesh out over time.

Excel String Manipulation

Does any cell in a range contain a substring?
(Is the string contained in cell F4 a substring of any of the cells in column B)

=COUNTIF(B:B,"*"&F4&"*")>0

Which row number in a range contains the partial match?

=MATCH(""&F4&"",B:B,0)

Return the contents of the column on the same row as the match.
(if the value A6 is found in the column A:A on AMAZON UPLOAD, then return the corresponding value in column O)

=INDEX(O:O,MATCH(A6,'AMAZON UPLOAD.xlsx'!$A:$A,0))

Excel Date Manipulation

Convert the date name into the date number

=MONTH(DATEVALUE(A1&" 1"))