Specific Days of the week

Question

Hello, I am trying to find how I can formula my data to show only specific days of the week (T, W, Th, F, S). I don't want to include Sunday and Monday as those days are zeroes and it throws off my line graph I want to show the days that do have data.

How would I do this?

patrick2788 · Answer

How are you producing your dates? Are you spilling them?

oliverscheurich · Answer

THqst&nbsp;=CHOOSE(IF(MOD(ROW(B1),5)=0,5,MOD(ROW(B1),5)),"T","W","Th","F","S")You can try this formula as shown in the screenshot.

peterbartholomew1 · Answer

THqst&nbsp;Using Excel 365 or Office 2021&nbsp;= FILTER(data, WEEKDAY(date)&gt;2)&nbsp;where data may be an entire table or simply a column of values for plotting.&nbsp; Other FILTER formulas that work with strings rather than dates, include&nbsp;= FILTER(value, NOT((weekday="Su")+(weekday="M")))

or, more complicated, to use the Boolean OR function

= FILTER(value,
      MAP(weekday, LAMBDA(wd,
          OR(wd={"T","W","Th","F","S"})
      ))
   )&nbsp;&nbsp;

Forum Discussion

Specific Days of the week

3 Replies

Resources