Taking into account month AND year
I have two columns. One is the date that the form was submitted, and the other tells us which quarter we received it. Our fiscal year is from April 1 to March 31. This formula works great, but I've realized it won't account for the change in year. Currently, we are in 2020/21, but as of April 1, we will be in 2021/22. How can I adjust my formula to identify the year?
I think Ideally it could appear Q1-20/21 or any variation really. I just have no idea how to incorporate the YEAR function.
Help Article Resources
Check out the Formula Handbook template!