day name

[csuu]

what is the formula for the day name (not number)of a date? For example, May 8, 2002 is Wednesday. The only formula I found in Excel, DAY(), gives the day number of 4.

The spreadsheet in the DOS program SMART had the formula: DAYNAME().

Larry

 

[Steve Hartman]

Custom format the cell as "ddd" for WED or "dddd" for Wednesday

 

[sen_edp]

hello

format the cell that contains the date
using custom format

dddd

 

[Asala42]

G'day,

How about: =Text(A2,"dddd")

where A2 holds your date.

Adam

 

[csuu]

On 2002-05-08 14:04, Asala42 wrote:
G'day,

How about: =Text(A2,"dddd")

where A2 holds your date.

Adam

Thanks! Formula works great!

Larry