My project over the next couple weeks is to create a budget spreadsheet, so expect a few questions here as I try to do this.
Today’s question: I’m trying to create a filter for a date range, comparing that date to today to determine the last paycheck and my next one, and filter the list of future paychecks over the next 2 years to filter out ones that are previous checks.
My goal is to have the filter functions automatically refresh based on the calculations. I have tried both standard and advanced filters, and neither seem to dynamically update. What is the best way to achieve this functionality? I do know some Python to code a macro if that’s what is required.
Running LibreCalc 7.2.7-5 from the Manjaro repos.