Forum Discussion
Moving Average only on working days
Hey, I have question concerning moving average. How do you make sure you only making a moving average on working days (monday - friday), so saturday & sunday can not be taken into account. Cu...
I added an example. For Tuesday he does not find any earliest first date, because this would be saturday.
In fact report should take Tuesday in such a case. For Wednesday first date would be sunday, but this is not in data set, report should take Friday.
Can this logic be made without IF formula, because this will make it very complex assuming the holidays as well.