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’?