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...
=IF(WEEKDAY(Q18,2)>5,Q18-WEEKDAY(Q18,2)+5,Q18-WEEKDAY(Q18,2)-2)
=W18+CHOOSE(WEEKDAY(W18),1,0,-1,-2,-3,0,-1)
=WORKDAY.INTL(M10+181,-1,"0111011",$J$9:$J$38)
I also have these 2 that need to calculate the same, Monday thru Thursday and back date to Thursday if it falls on Friday. Are you able to assist with those as well? I appreciate the help!
=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:
