Forum Discussion

THqst's avatar
THqst
Copper Contributor
Dec 06, 2022

Specific Days of the week

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 l...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Dec 06, 2022

THqst 

Using Excel 365 or Office 2021

 

= FILTER(data, WEEKDAY(date)>2)

 

where data may be an entire table or simply a column of values for plotting.  Other FILTER formulas that work with strings rather than dates, include

 

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

 

 

Resources