When I copy this formula down column b, and column a hasn't been filled in
yet, I get a column of "Saturdays". How can I hide the formula so column b
stays blank until column a is filled in?

"FSt1" wrote:

hi
column A column B
2/5/2007 =TEXT(A2,"ddd") = Tue
=TEXT(A2,"dddd") = Tuesday


Regards
FSt1

"Windy" wrote:

column a will be filled in with dates as needed; how do i get column b to
automatically fill in the corresponding day of the week to match that date?