I would guess your Calculation mode is set to Manual.

Mike addressed the second part.


Gord Dibben MS Excel MVP


On Fri, 16 Jan 2009 10:53:01 -0800, Dylan @ UAFC
wrote:

I am trying to auto fill or copy down this
formula, when I copy down Saturday shows up in every
cell, even if the orginal cell blank

How can I re-work the function so the cell will remain
blank until data is typed in the other cell