Need a data validation formula for following assuming you are putting data validation in cell A2.

The user should be able to enter a date in following format

  1. MM/YYYY for the year 2018
  2. QQ/YYYY for the years 2019 to 2021

The solution to above challenge will be published after a month i.e. on 16-Jan-18.