# Return the name of the day from a date

#### T

##### New Member
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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### BigC

##### Well-known Member
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

##### Active Member
When A1 houses the date:

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

#### Mark W.

##### MrExcel MVP
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".

Replies
1
Views
193
Replies
3
Views
408
Replies
6
Views
598
Replies
1
Views
252
Replies
6
Views
478

1,181,644
Messages
5,931,194
Members
436,781
Latest member
acyiang

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back