I need a cell that will pull the previous month in this format yyyymm.
For instance, this is July, so I need the cell to populate 201606 (june 2016)
August should be 201607
Also, I need a rolling 12 month also, so if the result is 201607, I need another cell to populate 201508
Can anyone help??