Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging.
I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that.
And using "is in the next 1 day" also pulls in today, which I don't want.
I've done some formula-driven work on the underlying sheets, but each of those sheets needs to be "touched" and saved to be included in the report.
Any ideas on how to leverage "tomorrow" in reports?
Thanks.