# Convert a date field in excel to day of week

Solved/Closed
Related:

- Excel turn date into day of week
- Excel date format dd.mm.yyyy - Guide
- Time of day clock stopped - Guide
- Dash becomes date on excel ✓ - Office Software Forum
- Windows calendar show week number - Guide
- Hay day download pc - Download - Simulation

## 5 responses

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

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