How do I get the day name into a cell in Excel?

"Simple example:

A1 cell: 1/8/2009
B1 cell: =TEXT(WEEKDAY(A1),""dddd"")

This will, for the given date, print the corresponding day.

Is this what you wished ?"

Another possibility, depending on what you want to do with the date afterwards, is to set the cell's format to Custom: dddd

"A1 cell: 1/8/2009
B1 cell: =A1 then press ctrl+1 (format cell)
select number tab, click custom then type ""DDDD"" on the type txtbox"
"A1 cell: 1/8/2009
B1 cell: =A1 then press ctrl+1 (format cell)
select number tab, click custom then type ""DDDD"" on the type txtbox"

"Displays current date

=TEXT(WEEKDAY(MONTH(TODAY())),""dddd"")

Displays current date with required required text.

=CHOOSE(WEEKDAY(MONTH(TODAY())), ""S-U-N-D-A-Y"",""M-O-N-D-A-Y"",""T-U-E-S-D-A-Y"",""W-E-D-N-E-S-D-A-Y"",""T-H-R-S-D-A-Y"",""F-R-I-D-A-Y"",""S-A-T-U-R-D-A-Y"")"

Format Cells - Date - Calendar Type (select Gregorian English) - Type (section has your required format Wednesday, March 14, 2001)