4 Replies Latest reply on Feb 28, 2017 4:29 PM by fscales

    Creating Date Range Worksheet for Order Table

    fscales

      Looking for a way to create a worksheet (daughter table) from an order entry table that allows the user to specify a number of "plays per day" of an announcement based on the contract's start date and end date, grouped by broadcast weeks (Monday-Sunday).

       

      Our order schedules range from 2 weeks upwards to 12 months, and it would look something like:

                                              M          T            W             T                F            S           S          Wk Total

      2/27/2017 - 3/5/2017  |   3          3              3            3                3              x           x             15

      3/6/2017 - 3/12/2017  |   4          4             4             4                4              2          2              24

                                                                                                                                                  ------------

                                                                                                                                  Total Plays: 39

       

       

      Thank you.