Hi,
in column G I have a range of dates, mostly without breaks.
How can I easily select a period of dates between to dates? I am trying to use one cell with "From date" and one cell with "To date",
Ex. If I wanted to select all dates between 2021-09-15 and 2021-09-13, and if left blank I would get all dates. And I will get all data in the other columns where the dates match.
From date: 2021-09-13
To date: 2021-09-15
All suggestions are welcome. Perhaps there is a better way using comboboxes or dropdowns for year, month and day? Or slicers?
EDIT:
I spelled "period" wrong in the thread title, perhaps someone could correct it?
in column G I have a range of dates, mostly without breaks.
Date |
2021-09-15 |
2021-09-15 |
2021-09-14 |
2021-09-14 |
2021-09-14 |
2021-09-13 |
2021-09-13 |
2021-09-13 |
2021-09-12 |
2021-09-12 |
2021-09-12 |
How can I easily select a period of dates between to dates? I am trying to use one cell with "From date" and one cell with "To date",
Ex. If I wanted to select all dates between 2021-09-15 and 2021-09-13, and if left blank I would get all dates. And I will get all data in the other columns where the dates match.
From date: 2021-09-13
To date: 2021-09-15
All suggestions are welcome. Perhaps there is a better way using comboboxes or dropdowns for year, month and day? Or slicers?
EDIT:
I spelled "period" wrong in the thread title, perhaps someone could correct it?