Finding a blank cell and the value in the cell to the left

  I would like to find the first blank cell and then the value in the cell to the left - i.e. "Tuesday".   The formula below finds the blank cell and returns the cell address $C$6 =CELL("ad...