Posted: 11/19/2005 3:05:43 AM EDT
| Putting together a time sheet and looking for a function that will import a range of dates (from beginning to end of pay periond) into their appropriate columns. Searches of onboard help files have resulted only in frustration. |
|
I think you mean you want to "fill" a range of cells on your spreadsheet, not "import" a range from another program or file. The following works in Excel 2003: Enter a start date in the first column Drag across to select the cells in the desired number of columns From the Edit menu, select Fill, then Series From the Series dialog box, enter the following: . Series in: select Rows . Type: select Date . Date Unit: select Day, Weekday, Month or Year . Step Value: enter the interval you want between the dates -- in number of days, months, weeks, whatever Click the OK button. Hope that helps. |
|
type a date at the top of a row. Now click the bottom right of that box & drag it downward. It should continue adding days to the date in the box above such that if you typed "1/1/01" in the top box, the column would look like 1/1/01 1/2/01 1/3/01 1/4/01 1/5/01 1/6/01 etc. for as far as you drag it. |