Excel Prediction Competition Follow up: Previous day's demand

How to add a column with the previous day's demand in Excel. Also, how to add a moving average column that accounts for weekend/weekday effects.

BYU,analytics,Excel,regression,