Return the name of the day from a date

[T]

Probably a simple function that I've overlooked but can anyone help out.
How do I return the name of the day (eg. Monday, Tuesday etc) from a date?

Cheers

 

[BigC]

Create a custom format for the cell as:
"dddd" => underlying value in the cell will still be the serial number of the date, but will display only as "Tuesday", etc.

or enter the following formula (assuming your date is in A1)
=weekday(A1,1) returns a number from 1 to 7 representing the day of the week. To convert the number to the name of the day (eg Tuesday) you'll need to create a lookup table of day numbers (say B1:B7) & names (C1:C7), then use
=vlookup(weekday(A1,1),$B$1:$C$7,2,False)

HTH
BigC

 

[Albert 1]

When A1 houses the date:

=TEXT(A1,"dddd")
This message was edited by Albert 1 on 2002-10-16 06:02

 

[Mark W.]

On 2002-10-16 04:37, T wrote:
Probably a simple function that I've overlooked but can anyone help out.
How do I return the name of the day (eg. Monday, Tuesday etc) from a date?

Cheers

Format as "dddd".