From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Calculating day of the week totals from a large transaction list

Calculating day of the week totals from a large transaction list - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Calculating day of the week totals from a large transaction list

“

- [Instructor] With some worksheets 2 like the one we're looking at here, 3 a transaction list of about 1800 rows. 4 It's important to know day of the week for 5 transactions, sales, and other kinds of data. 6 And in this worksheet and column E, 7 you see various data entries. 8 We could be setting up a new column, not truly necessary, 9 but one approach to showing day of the week 10 is simply to change the format. 11 As I click column E here, the date column. 12 In the number group, it's on the home tab. 13 We can click the drop arrow and choose a long date. 14 It takes up a lot of horizontal space, 15 but it does indicate which day of the week. 16 And if we simply want to use the data from time to time 17 to find out the day on which a particular sale occurred, 18 this is going to meet our needs. 19 But I'm going to undo that with Control Z, 20 we might want to have a separate column. 21 This too isn't truly…

Contents