Displaying (or not) Weekday
 

Col A contains a date that I enter.
Col B contains the formula =TEXT(WEEKDAY(A1), "DDD") which, when I enter a
date in Col A, returns the day of the week.

The entire Col B is formatted with the weekday formula. If Col A contains no
date, then Col B returns the weekday "Sat" all the way down the sheet. (Why
"Sat" I don't know.)

My question is: How can I hide the display in Col B until I populate Col A
with a date?

Displaying (or not) Weekday
 

Try this:

=IF(A1="","",TEXT(A1,"ddd"))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Alice M." wrote in message
...
Col A contains a date that I enter.
Col B contains the formula =TEXT(WEEKDAY(A1), "DDD") which, when I enter a
date in Col A, returns the day of the week.

The entire Col B is formatted with the weekday formula. If Col A contains
no
date, then Col B returns the weekday "Sat" all the way down the sheet.
(Why
"Sat" I don't know.)

My question is: How can I hide the display in Col B until I populate Col
A
with a date?

Displaying (or not) Weekday
 

hi
=if(A1="","",Text(A1,DDD))
you can use this technique whenever you are getting data that you don't want
but know that your formula is right such as the #DEV/0! error and others.

Regards
FSt1

"Alice M." wrote:

Col A contains a date that I enter.
Col B contains the formula =TEXT(WEEKDAY(A1), "DDD") which, when I enter a
date in Col A, returns the day of the week.

The entire Col B is formatted with the weekday formula. If Col A contains no
date, then Col B returns the weekday "Sat" all the way down the sheet. (Why
"Sat" I don't know.)

My question is: How can I hide the display in Col B until I populate Col A
with a date?

Displaying (or not) Weekday
 

Try

=IF(A1="","",TEXT(WEEKDAY(A1), "DDD") )

Your formula returns Sat because XL believes that day zero was a Saturday.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Alice M." wrote in message
...
Col A contains a date that I enter.
Col B contains the formula =TEXT(WEEKDAY(A1), "DDD") which, when I enter a
date in Col A, returns the day of the week.

The entire Col B is formatted with the weekday formula. If Col A contains
no
date, then Col B returns the weekday "Sat" all the way down the sheet.
(Why
"Sat" I don't know.)

My question is: How can I hide the display in Col B until I populate Col
A
with a date?