Sunday to Saturday. Sunday = Day 1, Monday = Day 2, etc.
@akern, check out this previous post that was based on DAYOFWEEK, which may be helpful as well. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Matching-dates-from-two-data-sets/m-p/6612#M431
