# Convert a date field in excel to day of week

Solved/Closed
Related:

- How to sort by date in excel
- How to sort bookmarks in chrome - Guide
- Excel date format dd.mm.yyyy - Guide
- Spotify sort by genre - Guide
- How to find position in excel ✓ - Office Software Forum
- How to take screenshot in excel - Guide

## 5 responses

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549

Feb 25, 2011 at 09:53 AM

Feb 25, 2011 at 09:53 AM

Sorry C, didn't realize you couldn't sort your data like this.

You could use Filter. Top menu > data > filter > AutoFilter. Now your are able to group one type of day together, giving you a chance to copy/paste for a fixed list.

You could also use two extra columns:

One column to put this formula in:

Second column to paste special the data from the formula column as value.

Now you can sort your data as you are used to.

Note: that any unwanted columns can be hidden for a cleaner looking sheet.

Best regards,

Trowa

You could use Filter. Top menu > data > filter > AutoFilter. Now your are able to group one type of day together, giving you a chance to copy/paste for a fixed list.

You could also use two extra columns:

One column to put this formula in:

=IF(WEEKDAY(A2)=1,"Sunday",IF(WEEKDAY(A2)=2,"Monday",IF(WEEKDAY(A2)=3,"Tuesday",IF(WEEKDAY(A2)=4,"Wednesday",IF(WEEKDAY(A2)=5,"Thursday",IF(WEEKDAY(A2)=6,"Friday","Saturday"))))))

Second column to paste special the data from the formula column as value.

Now you can sort your data as you are used to.

Note: that any unwanted columns can be hidden for a cleaner looking sheet.

Best regards,

Trowa