98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
jay has attended:
Excel Intermediate course
Excel
How do I place dates on a spreadsheet for a whole month without typing the dates for the whole month?
Dates autodate autofill dateseries series
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |