3 years of data, twice a year
I'm not sure this is even possible, but we want to display 3 years of data at year-end and then at mid-year. So, for the current data, we want the following: Dataset 1 = 7/1/2017-6/30/2020, Dataset 2 = 1/1/2018-12/31/2020. Ideally, this would be rolling, but if we have to manually update, that's fine too - I'm just not sure what formula to use for the dates.
Help Article Resources
Check out the Formula Handbook template!