How do I place dates on a spreadsheet for a whole month without typing the dates for the whole month?

Hi Jay

On a monthly basis:

1. At the top of your date column type the starting date e.g. 1/2/08

2. Autofill the column down holding the RIGHT mouse button down

3. From the menu which comes up when you release the button choose SERIES

The dates should now be in sequence from the date you typed as a start date

For a more permanent solution:

4. type the start date at the top as above (lets call this STARTCELL)

5. type a formula into the cell below which adds 1 to the cell above (STARTCELL)

6. autofill this down 29 cells using the LEFT mouse button

This creates a formula in each cell which increases the date above it by one day; at the start of each month just change the date in STARTCELL


Best of luck!

Alan