Get instant live expert help on I need help with excel format day of week

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi I formatted a list of dates using custom format ddd on one column and mmm on the next column so each date now shows as a day of the week and a month. I want to be able to filter, sort and pivot the data by day of the week / month, but the filter, sort and pivot only looks at the date value not the displayed value day of the week or month. Please help. Thanks, Simon
Solved by B. B. in 18 mins
I want to find out how to change the first day of the week to monday and the last day of the week to sunday. currently the first day is saturday and last day is friday
Solved by O. J. in 28 mins
I need to break down data by hour of day, day of week and month of year
Solved by G. D. in 11 mins
How do i look up a value using two criteria- week # and day of the week?
Solved by E. S. in 23 mins
I need help refiguring a chart in excel to calculate lunch deductions and include the day of the week
Solved by D. Y. in 22 mins