Auto fill cell reference

[Kim K]

In excel 07, I want to be able to type in one cell the date of the beginning
of the pay period, then have it auto fill in the 2 weeks of dates for the
payperiod. IE, at the top of the time card I have a cell that says input the
first date of the new time period, below that is a 2 week chart of 14 days
that I want to fill in with the starting date input above.

2nd quesiton, in excel if you open more than one workbook, you can not
display both at the same time, in XP I was able to edit the file associations
with a /e "%1" to open several docs at the same time and place then side by
side. How can I do this with Office 07 and Vista?

 

[Sean Timmons]

Assuming your input cell is A2
Step 1:

in the 1st of 14 cells, type =A2
2nd cell =A2+1
etc.
And format all cells as Date

try:

Tools - Options - make sure Windows in Taskbar is checked.