SAMPLE SPREADSHEET
Excel Help.xlsx

It will always be either East or West.

I want the equation to automatically put the day 1 of east or west on the cell in column B that reflects the date in column A- so if B4= 1/6/2014, I want it to put the value of G6 in cell B11.