Quarterly Revenue Tracker that rolls over YoY
I've created a revenue tracker for 4 quarters but the date ranges are fixed and last timeframe has passed it will need to be updated. How can i add a function so revenue can continue to be tracked without my intervention?
Here is a snap of my formula which actually covers the last 2 Q's of 2021 and first 2 Q's of 2022. Once we're past 2Q-2022 I have to revise the formulas as i have it now:
Help Article Resources
Check out the Formula Handbook template!