Selecting records from a date range

[Parker_Smale]

Making another reply to link directly to the official Grist answer to this question!

Creating a summary table based on multiple date ranges

If you want to create a summary table based on records within a specified date range (or several different date ranges), you can do so using a formula column. In your table, create a new column to contain your formula. This formula will return True if the date falls within the given date range and False if it does not. You can also modify the formula to return more specific details - which I show towards the end of the example. Then, you can create a summary table grouped by this new column to …