Formula - Weekly average for the fist three quarters in a year
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 ...
dherring_wakehe
msharp