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

[suganya]

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.