Any idea of getting weekdays order


I need to get orders only on weekdays.i need an idea to do this?

Plans to get orders on weekdays and delivery the orders on weekends.

You can use Date Math.
Weekday(Date) in a math column will return a number between 1 and 7 representing the day of the week for the supplied date, beginning at 1 for Sunday.
You could then use an if-then-else column to test if the given date is a weekday, ie:

  • If weekday equals 1, then false
  • If weekday equals 7, then false
  • Else true

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.