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.

=TODAY()-WEEKDAY(TODAY()+1)+TIME(14,0,0)



Read more here: https://stackoverflow.com/questions/67016895/from-last-friday-2-pm-excel-formula

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: