AnsweredAssumed Answered

Creating Date Range Worksheet for Order Table

Question asked by fscales on Feb 28, 2017
Latest reply on Feb 28, 2017 by 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.

Outcomes