Question: how to convert date to yyyymm?
Answer: To convert a normal Excel date into yyyymm format (e.g. 9/1/2017 > 201709), you can use the TEXT function.