Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
You are back my friend .
Try this:
If(Weekday(DATE) <> 'Sat' or Weekday(DATE) <> 'Sun', WeekDay(DATE))
Best,
Sunny
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
You can also try using
=weekday(DATE)
as calculated dimension, not as expression.