How to hide day

[sureshift]

I have this equation.
=Text(f1,"DDDD") Which comes out as 3/1/08 Thursday.
How do I get it to come up blank till I put in a date.
At the moment it comes up like this.
3/1/08 Thursday
Friday
Friday
Thanks in advance Larry

 

[T. Valko]

Hmmm...

To answer your question, try it like this:

=IF(F1="","",TEXT(F1,"dddd"))

You must be using a date format of d/m/yy. Also, you must be using the 1904
date system. Using the default 1900 date system an empty cell will evaluate
to weekday Saturday. Using the 1904 system an empty cell evaluates to
weekday Friday.

 

[akphidelt]

Try this, im assuming you are using that formula and dragging it down across
multiple rows... so in F1 put the formula

=IF(OR(F1=0,F1=""),"",TEXT(F1,"dddd"))

Then drag and drop that formula.

 

[Gord Dibben]

=IF(F1="","",TEXT(F1,"DDDD"))

BTW "DDDD" will show Thursday only

If you want 3/1/08 Thursday, use "d/m/yy DDDD"


Gord Dibben MS Excel MVP

 

[T. Valko]

Using the default 1900 date system

That would be for Wintel machines. I guess the 1904 date system is the
default for Macs.

 

[sureshift]

Thanks for your help it worked..