Hello, I'm currently creating a metrics tracking sheet that is updated via reports from SAP. The reports run from Sunday-Saturday for the current week. The days in the future only carry a zero value since they have not occurred yet and cause my formulas to display the zero value. I'm looking for a way to have them display blanks based on the WEEKDAY() formula, but still hold previous values. (When it's Tuesday, still display Monday). The big kicker though, is that we review Friday on Mondays. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
@Peter_SSs, Thanks for the response and assistance!
I believe we are there. I added -1 to the Today function as we are reporting on previous day metrics, yes always a day behind. I was getting a zero for today (Wednesday) when SAP reporting hasn't yet occurred for Wednesday. I believe this is working properly. I'll check back in tomorrow as well.
Upvote
0
Good news! Thanks for letting us know.
Still working! Just realizing though. When we report out on last week all fields will probably be blank on Monday... I'll probably work some VBA to fix that, but we'll see how it goes. Great work @Peter_SSs
Upvote
0
Similar threads
- Question
