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