Question: how to change date in excel to just month and year?
Answer: Convert date to month and year with Format Cell option 2# right click on the selected cells and click on “Format cells…” 3# Select “Custom” under “Number” tab, then type the custom format “yyyymm”in type. 4# you will see that the date value is converted to month and year.