Hello.
For the queries, would it possible to create a new data range "Last year & this year to YESTERDAY"? As far as I know the closest one we have is "Last year & this year to date" (see the screenshot)
It would be super helpful as, every day, I need to manually delete today's data.
Thank you.
Regards,
+6Hi
Thank you for your feature request! I checked in with our support team, and it turns out this functionality is currently available using the Custom date range option.
One of the best parts about this feature is that the date fields are flexible; you can use specific dates or natural language. For example, you can set the Start date to "first day of January last year" and the End date to "yesterday" to keep your report dynamic.
How to set it up:
Select Custom date range from the Date range dropdown menu.
Enter your desired dates or flexible terms (like "yesterday") into the Start and End boxes.
For more details on how to use these settings, you can check out our guide here: About custom date ranges in Google Sheets.
+6+6+6Already have an account? Login
Don't have an account? Sign Up
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.