Date Formula

[ypurcaro]

Hi,

I have created a formula in cell C1, something like this =text(b1,"dddd"). Other words, when I type the date in cell B1, the day will automatically pop up in cell c1. It works fine but there is one problem which is after I clear the date in B1, the day still stay there. Now, how do I get rid of the day when the date in cell b1 was erased?

Thanks.

[jeffreybrown]

How about...

=IF(B1<>"",TEXT(B1,"dddd"),"")

[rcm]

try this

=IF(B1<>"",TEXT(B1,"dddd"),"")

[Richard Buttrey]

How are you clearing/erasing B1?

I suggest you upload your workbook and describe exactly what you do.

[daddylonglegs]

Try this version

=TEXT(B1,"dddd;;")

[ypurcaro]

How about...

=IF(B1<>"",TEXT(B1,"dddd"),"")

Jeff,

It works, thanks a bunch!

[ypurcaro]

daddylonglegs, Richard Buttrey & rcm:

Thank you for all your helps. They all work well.

Have a happy holiday!

[jeffreybrown]

You are welcome and Happy Holidays to you and yours