I've never understood why but blank cells always evaluate as saturday

Because Excel recognizes a day 0. Think of the date serial numbers. 1 is Jan
1 1900 which Excel says is a Sunday.

1/0/1900 is a valid date in Excel and Excel evaluates day 0 as the last day
of the prior month so 0 or an empty cell represents 12/31/1899 which Excel
evaluates as Saturday even though 12/31/1899 is not a valid date.

Basically it's one of Excel's many quirks!

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Gord,

I've never understood why but blank cells always evaluate as saturday even
if you use

=TEXT(WEEKDAY(A1),"dddd")

so the calculation manual/auto may not come into it.

Mike

Blank cell

"Gord Dibben" wrote:

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