Is there a way to set a date range filter to be dynamic dependent on who is opening the workbook?

There are a few ways to do this

  1. Custom links that set the values.
  2. Set up a formula that utilizes CurrentUserEmail to dynamically switch values in a column.