Get instant live expert help on How do I get day of week from date

To get a feel of things based on production and their capabilities. Weekly graph with colored lines for true average to see trends in production, product downside or consistent trends week after week or a stacked chart daily showing where production was spent that day (wires, pads, halo, kits, glue) that will allow us to see trends by the day or date of the week. Total product completed per hour

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

I need to get some trend data. I have my day of the week all equal to a numerical value (1-7). However, my date/time field is throwing this off. It is currently: 12/10/2017 12:45:00 AM. But I only need hh. I want to show the count of calls that come in per hour on a given day of the week.

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

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