Here's our Microsoft Office Tip for.. January 18, 1999
Click Here to see a complete list of all of our previously released Tips!
More on Automatic Lists in Excel
In an earlier Office tip we showed you how to make Automatic Lists in Excel. You can also use this method to do the same for any sequential time period (weeks, months, etc.). That is, if you'd like to create a list of sequential Mondays, you can enter the date for the first Monday in one cell, then the date of the second Monday in an adjacent cell. Then highlight both cells and drag. Excel will create a sequence of Mondays (or whatever day you choose). All the dates in the sequence will be seven days apart.