Techniques for creating date series

On this worksheet we see some column headings … and columns A, C, E, and G. … And imagine them … each on a separate worksheet along with some other data. … And what we're going to show you here are some … quick ways to create date series. … In column A we've got a heading mid-month report; … It doesn't have to be the fifteenth necessarily, … but we want to fill this in for … the other months of the year … or maybe even going up to two years. … Now we could put in the February date here … or highlight them both, … we could take that approach. … But I'm going to be using the right mouse button, … and we can be a little casual about how far we drag this … because if we drag it too far, … it can get rid of the extras and so on. … I'm pointing to the lower right hand corner, … that's called the fill handle. … I hold down the fill handle with the right mouse button, … and drag down to about row 25 or so. … But when I let go, there's a pop up menu. … And I want to fill this with months. … Got the fifteenth of every month. …