I would say you are going to need to “fork” the report, have a specific one that offsets correctly based on current date for data explorer and then a second report for manual usage.
I know it is a bit annoying having copies, but it feels like the simplest solution.