Forum Discussion

Copper Contributor

Nov 27, 2024

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...

excel

Formulas and Functions

JenniL0211

Copper Contributor

Nov 27, 2024

=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!

HansVogelaar

MVP

Nov 27, 2024

=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)

JenniL0211
Copper Contributor
Nov 27, 2024
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?
- HansVogelaar
  MVP
  Nov 28, 2024
  This is what I see:
  - JenniL0211
    Copper Contributor
    Dec 02, 2024
    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! 🙌