The formula returns only Tuesdays and Thursdays as the formula is copied down. If the start date in B5 is changed, new dates are dynamically generated. One of the the arguments provided to WORKDAY.INTL is called “weekend”, and controls which days are considered non-working days. The weekend argument can be provided as a number linked to a preconfigured list, or as a 7-character code that covers all seven days of the week, Monday through Saturday. This example uses the code option to “filter out” days that are not Tuesdays or Thursdays. In the code, 1’s represent weekend days (non-working days) and zeros represent work days, as illustrated with the table in D4:K9. We only want to to see Tuesdays or Thursdays, so we use zeros for these days, and 1’s for every other day: As the formula is copied down, the WEEKDAY.INTL outputs only Tuesdays or Thursdays. All dates are formatted with the custom number format " ddd d-mmm-yyyy".
Custom days
To customize which days are returned, just adjust the code. For example to output only Mondays, Tuesdays, or Fridays, you can use:
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
