Forum Discussion
Formula Help
I have the following formula currently in use in a spreadsheet. =T25+CHOOSE(WEEKDAY(T25),1,0,-1,-2,-3,0,-1) This is to calculate a Monday or Friday date in my spreadsheet. Our calendars have ch...
Hans...you are a life saver! It's been so long since I've modified this that I forgot what the 0,0,1,1 etc meant. 😄 I truly appreciate you and your knowledge!
Would you be able to assist with 1 more? I overlooked this one in the mix of things.
=IF(WEEKDAY(G21,2)>1,G21-WEEKDAY(G21,2)+1,G21-WEEKDAY(G21,2)-6)