Convert a date field in excel to day of week
Solved/Closed
Related:
- Excel sort by day of week
- How to stop today function date changing every day in excel - Best answers
- Excel filter by day of week - Best answers
- How to sort dates in excel by month day and year - Guide
- Excel date day of week ✓ - Forum - Office Software
- Excel formula 90 days from date - Guide
- Excel formula - Add days to date based on drop down selection ✓ - Forum - Excel
- How to stop today function date changing every day in excel - Forum - Excel
5 replies
TrowaD
Feb 25, 2011 at 09:53 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
TrowaD
Feb 24, 2011 at 10:29 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 24, 2011 at 10:29 AM
Hi C,
When you format a cell use the reference "dddd", this will show you the full name of the day.
Best regards,
Trowa
When you format a cell use the reference "dddd", this will show you the full name of the day.
Best regards,
Trowa
thank you for taking the time to answer this. I knew about formatting the cell that way to get the day of week. My question is how can I make the day of week something that I can sort on so, as example, I want ALL mondays grouped together so I would sort on the day of week. you cant do this with format cell, it still has the date for the actual value it just shows the day of week
thanks
thanks
shameem007
Jun 23, 2011 at 01:02 AM
- Posts
- 3
- Registration date
- Monday June 20, 2011
- Status
- Member
- Last seen
- June 23, 2011
Jun 23, 2011 at 01:02 AM
When you format a cell use the reference "dddd", this will show you the full name of the day.
Didn't find the answer you are looking for?
Ask a question