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)
Which row number in a range contains the partial match?
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)
Excel Date Manipulation
Convert the date name into the date number