Hi Deepak. Thanks.
What are you doing exactly? I don't understand the second part of the formula.
And why doesn't the average formula work? Also, how do I then take the average of that 4 day period? I want the daily average of sales over the 4 day period, not just the days that show up. So it would be (.5+.5+.333)/4 days. Thanks!