formula in Excel to calculate rolling daily average of sales total by date

Can you please elaborate? Or attach a sample Workbook?

Ofcourse there is if:
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Unable to understand the desired output..

I can see where you get the 170, but not the 90 value.

Usually when I calculate a "rolling" or "moving" average, I use the regular AVERAGE() function with the proper combination of relative and absolute references. Are you familiar with using absolute and relative references when copying functions?

You might also consider one of the other built in average functions (average, averagea, averageif, averageifs): http://office.microsoft.com/en-us/ex...920.aspx?CTT=1

Hi,

Assuming the 90 in C14 is wrong and you want the average on Friday 13th then in C8 copied down

Formula:

Please Login or Register  to view this content.

Hi,

No. Formatting is just that. Merely different ways of representing the underlying number. The number is a date number and hence can be used in date arithmetic without any further manipulation.