Can I compare custom time periods using the Comparisons sheet?

[jono]

Hi @rambruinllc and @susandennis ,
The Comparison report offers lots of pre-built time periods in cell B3 and C3 including:

This Month, Last Month, This Week, Last Week, This Year to Date, Last Year to Date, This Quarter, Last Quarter, Last Year

If you want to manually enter your own time period, change the dates in cell H13 and I13 for the 1st column and H14 and I14 for the 2nd column. If you make this change, the dropdown ranges won’t work anymore because you will have overridden the formula for them. You might also want to add the manual date range above the dropdown options, since they dropdown selection won’t be used anymore.

To get the sheet back to normal, you can reinstall it from the Tiller Money Labs Add-on.

Here’s more about the Comparision sheet just in case:

Docs: Comparisons report

What is the Comparison Report? An easy way to better understand your spending is by comparing it across two time periods. The time periods could be a week, month, quarter, or year. When your income or spending changes from one period to the next, you can gain a better understanding of what happened by looking at which categories or groups changed the most and least. Our financial comparison report is designed to help you gain those insights. The sheet compares your spending or earnings acros…

Jon