What is the best way to create an Income Statement that contains 2 columns, the first column is "Current Quarter" and the second column is YTD column? I am trying to figure out the best formula for the current quarter. Is there a way to input a range?
You can use multiple periods in the Actual formulas by separating with a comma. So for a "Current Quarter" you could have 7,8,9 for the period then use the Actual YTD formulas for your second column using period 8 for example.