View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alice M. Alice M. is offline
external usenet poster
 
Posts: 11
Default 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?