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
- MM/YYYY for the year 2018
- 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.