1 Reply Latest reply on Nov 7, 2016 9:11 AM by Norbert Maijoor

    Calculate 'number of working days in this week for this month'

    Ramya Sadagopan

      I have a weekly dashboard to show the current week’s target based on the Goal and 'number of working days in this week for this month' AND progress made.

       

      Issue: ‘Current Week’ in this month could have either 5 days or less than 5 Days. Like this month the first week had only 4 days in Nov and the last week has only 3 days in Nov.

       

      Current Month = Nov

      Sales Goal for this month is $110K

      Number of working days this month = 22 days

       

      In this case, my goal for Nov 2016,

      Week 1 (4days) = 20K

      Week 2 (5days) = 25K

      Week 3 (5days) = 25K

      Week 4 (5days) = 25K

      Week 5 (3days) = 15K

       

      How do I calculate the number of days in ‘Current Week in Current month’?