how do I set up a formula showing the day based on date?

[Guest]

I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like
another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.)
....in otherwords, calculated by what date appears in the former cell... how
do I do that?

 

[Guest]

.....set B1 =A1

 

[Guest]

Custom Format cell as "ddd" (no quotes)

 

[Guest]

In B1: =A1
format cell as: ddd

 

[Peo Sjoblom]

=TEXT(A1,"ddd")