Estimating Remaining Days

[sshutchinson]

In my data set I have data from Dec. 1-28th in column header "Date". Because there are 31 days in Dec., I need to estimate the rest of the data for the following dates: 29th, 30th, and 31st. To do so, I want to use a 7 day lookback. By that I mean, the 29th will use data from the 22nd. The 30th will use the data from the 23rd. The 31st will use data from the 24th. 

[sshutchinson]

First of all, thanks for your effort here. This output for the "New Method" doesn't include the 29th, 30th, 31st. The output should not have any forecasted dates outside the month. 

[jdminton · Accepted solution]

You're right. I had forgotten which days you were needing. This should be correct. Please mark as solved if this is what you were wanting. Thanks!