Formula to determine day of Week?

[erock24]

Can excel determine the day of the week? For example, if cell a1 = 3/27/2009, Is there a formula i could put in b1 that would = Friday.

 

[Smitty]

Here's one way:

=TEXT(A1,"dddd")

HTH,

 

[lenze]

=WEEKDAY(A1,1). Custom format the cell as "dddd", no quotes
lenze

 

[pedro-egoli]

If you want it to appear in Cell A1 along with date , put in date and format as
Custom/[$-C09]dddd, mm/d/ yy

Pedro

 

[Peter_SSs]

Similar to lenze's idea.
In B1 put =A1
and format B1 as Custom Format "dddd"