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.

Use dragging techniques to extend dates by weekdays only, month, or year

Use dragging techniques to extend dates by weekdays only, month, or year - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use dragging techniques to extend dates by weekdays only, month, or year

“

- [Instructor] When you're creating series 2 of dates in Excel, 3 you can rely on formulas much of the time, 4 but it's often going to be faster by dragging, 5 using the fill hand on the lower 6 right hand corner of a cell, 7 sometimes with the left mouse button, 8 sometimes with the right mouse button. 9 If we were doing a mid-month report in column A, 10 starting with January 15th, 2021, 11 one approach is in the cell below it, put in February 15th. 12 Highlight both of these 13 and then drag from that lower right hand corner, 14 it's called the fill handle, 15 using regular left mouse button. 16 There we are, so that's certainly easy and direct. 17 Another approach is after deleting this data, 18 is to do this with the right mouse button. 19 In other words, have only one date in place, 20 point to that lower right hand corner, 21 hold down the right mouse button, drag downward 22 and when we release the right…

Contents