I am trying to write a formula to look at data in one column on one sheet and depending on what it sees report that value in a single cell on another worksheet.  To be more specific, column A on one worksheet has dates from June 1 through Sept 1.  Column B has either "0" in it or "0.5" in it depending on the date.  I need my formula to look at the value in column B for today's date and insert that value into the single cell of the other worksheet.  I also need the value on the 2nd worksheet (single cell) to change automatically everyday.  Is there a formula that can do this??