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...
=Q18+CHOOSE(WEEKDAY(Q18),1,0,0,0,0,-1,-2)
=W18+CHOOSE(WEEKDAY(W18),1,0,0,0,0,-1,-2)
=WORKDAY.INTL(M10+181,-1,"0000111",$J$9:$J$38)
Thank you Hans! The Q18+CHOOSE(WEEKDAY(Q18),1,0,0,0,0,-1,-2) formula is still producing Friday dates, does something need to be modified?
This is what I see:
My Apologies, I was looking at the wrong formula. There is a lot going on in my spreadsheet :) I'm sure you'd have an easier time looking at and knowing exactly what to do! again, I appreciate your wisdom! 🙌