Hi, Data is displayed on a daily basis (mon - sat). I have converted the date to days of week, weeks, months, quarters, years. Iam trying to get the average weekly value for the time period 1/1/2015 - 10/3/2015. This would be displayed on 10/5/2015 and it would contain the same value for the rest of the year. So in essence, it is one weekly average value for Q1 - Q3. I think I can do this in a tabulation, however I am looking for a formula on how to do this. Any help would be greatly appreciated. Thank you,
... View more