Supress Weekend Names

[#1]

I have a straight table withg data showing working dates only.

I would like to add a field showing the weekday name. I used the below function.

=weekday(DATE)

Problem is, now my straight table shows the weekends as well and I cannot find a way to suppress them.

Any ideas?

[sunny_talwar]

You are back my friend .

Try this:

If(Weekday(DATE) <> 'Sat' or Weekday(DATE) <> 'Sun', WeekDay(DATE))

Best,

Sunny

[sunny_talwar · Accepted solution]

Actually since we are checking for nots, I think it should be 'and' and not 'or'

Try this instead:

If(Weekday(DATE) <> 'Sat' and Weekday(DATE) <> 'Sun', WeekDay(DATE))

If that doesn't work, then this should def. wor:

If(Match(WeekDay(DATE), 'Mon', 'Tue', 'Wed', Thu', 'Fri'), WeekDay(DATE))

Best,

Sunny

[swuehl]

You can also try using

=weekday(DATE)

as calculated dimension, not as expression.