Get instant live expert help on I need help with excel day of week from date
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula for the drive spreadsheet to return the date of the first day of the month and the day from the start of the week.
For example, every month one should be 01-07-2018 then 01-08-2018
The other should change every week 01-07-2018 to 08-07-2018 to 15-07-2018
Solved by O. D. in 21 mins
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'm trying to extract day of the week from a time stamp to a new column and then the hour of the day from the time stamp into another column
Solved by D. J. 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