Days of the week

How do we get Excel to return the day of the week when we key in a date in a cell? Is there any formular for that or do we need to add-in anything?

Can u elaborate further? I think you have mistaken my intention as I am not formating the date to display day of the week. Instead, I want Excel to return to me in cell B1 the day of the week by referring to cell A1 which contains date.

eg.. in cell A1 = 3/12/2007
in cell B1 to return Monday

if cell A1 = 5/12/2007
then cell B1 to return Wednesday.

As Shg suggested

In B1 enter

=A1

Then right click cell B1 > format Cells > custom > dddd

VBA Noob

Gee.. thanks for that... so simple yet I am thinking toward the complicated way. :o