From Last Friday 2 PM. Excel Formula

I have a big formula that count from Last Friday 2 PM until next Friday 2 PM (+7). I put the Date part in another cell ( to facilitate view ). The below formula works ok, Except IF now is Friday > 2 PM until end of that day. Any calculations on this period will not take effect until Tomorrow (Saturday) I need to refine the formula to check if now is Friday +2.01 PM, to count from this time In addition, if not, use existing formula.


Read more here:

Content Attribution

This content was originally published by Waleed_wwm at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: