Convert a date field in excel to day of week
Solved/Closed
Hello,
I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so that all mondays are lumped together, etc. I guess I need to know if I can turn the results that show in the cell (day of week) into a literal that simply reads monday and I then can sort it.
any help is appreciated.
I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so that all mondays are lumped together, etc. I guess I need to know if I can turn the results that show in the cell (day of week) into a literal that simply reads monday and I then can sort it.
any help is appreciated.
Related:
- How to sort by day of the week in excel
- How to sort bookmarks in chrome - Guide
- It usually takes us just over a day to review your information - Facebook Forum
- Show week number in windows calendar - Guide
- Time of day clock stopped - Guide
- Number to words in excel - Guide
5 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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