Forum Discussion
Solved
Divide Sales Objective by number of working days
Hi everyone! I would like to request help with the following problem. I need to divide the sales objective by the number of business days in the month, the problem is that I can't sell half a car. ...
See the attached demo workbook.
Himroldan5,
HansVogelaarand I also must have been working on the problem in parallel. I did it a little differently. See my example! I did not want to throw it in the trash.
I have exchanged the example again.
That's a more 'modern' solution, I like it.
But there's something strange with the calculation of Easter Monday. I see this in your workbook:
=7*ROUND((4&-A1)/7+MOD(19*MOD(A1,19)-7,30)*0.14,)-6+1
This causes an error when Excel recalculates. It should be
=7*ROUND((DATE(A1,4,1))/7+MOD(19*MOD(A1,19)-7,30)*0.14,)-6+1