4 Replies Latest reply: Feb 4, 2018 1:36 PM by Bill Markham RSS

    Number of working days during a month

    Mohammad Adnan Ansari

      I am working on Retail Sales data.

       

      In some cities the stores works 7 days whereas in some they work 6 days a week and 5 days a week as well. My requirement is to find out the number of working days for a specific store during a month.

       

      I am using standard master calendar.

       

       

       

      The below are the table formats:

       

      City:

      -CityID

      -City

       

      Store:

      -StoreID

      -CityID

       

      City Operational Days:

      CityID

      Operational Day. (Sat, Sun, Mon etc)