Hello! How add formula date picker (date range) in column?
I have 2 tables. One table maintains a list of tasks with a start and end date.
In the second table, I want to make a pivot table with columns that would be a date range.
For example, there is a column with a range from April 13 to April 17, and she would check the first table and display all the tasks that were at that time.
The formula I’m trying to do is:
Now the list gives only 2 dates, but I need a range
I do not need to do it through a filter, but I need a table with a breakdown.