Going to a new cell, if I type
07/22, if the column data format is set to a date, it interprets this to
July 22, 2020 (where
2020 is the current year). I want it to use the
22 as the year, I don't mind if behind the scenes it translates to
July 1, 2022 or
July 31, 2022 (although I prefer the 1st).
I have the data column set to
Month (08)/Year (30) i.e. expected output is exactly as typed
07/22. But even with this on, Sheets interprets the entry as Month, Day.