Auto Date Fill-in
 

Is there a way to fill in the first date (beinning of payperiod) and have
the spreadsheet fill in the remaining dates to the end of the payperiod?

B6 shows 4/16/05

B7 through B12 and B14 through B20 would auto populate their respective
dates.


Your help is appreciated!
Dreamweavn

If I understand correctly, to get every day of the pay period, enter 4/16/05
in A1, in B1 enter =A1+1 and drag B1 down as far as required, if you mean
weeks in the period, enter 4/16/15 in A1, in B1 enter =A1+7 and drag B1 down
as necessary, month =A1+28 etc. Thus when you change A1 to another date, all
the dates in the other cells will follow suit,
Regards
"Dreamweavn via OfficeKB.com" wrote in message
...
Is there a way to fill in the first date (beinning of payperiod) and have
the spreadsheet fill in the remaining dates to the end of the payperiod?

B6 shows 4/16/05

B7 through B12 and B14 through B20 would auto populate their respective
dates.


Your help is appreciated!
Dreamweavn

what about in seperate spreadsheets? I have a sheet for each day of the
week. I need to put the first day on sheet one and have the rest follow
suit. any ideas?

"Alan" wrote:

If I understand correctly, to get every day of the pay period, enter 4/16/05
in A1, in B1 enter =A1+1 and drag B1 down as far as required, if you mean
weeks in the period, enter 4/16/15 in A1, in B1 enter =A1+7 and drag B1 down
as necessary, month =A1+28 etc. Thus when you change A1 to another date, all
the dates in the other cells will follow suit,
Regards
"Dreamweavn via OfficeKB.com" wrote in message
...
Is there a way to fill in the first date (beinning of payperiod) and have
the spreadsheet fill in the remaining dates to the end of the payperiod?

B6 shows 4/16/05

B7 through B12 and B14 through B20 would auto populate their respective
dates.


Your help is appreciated!
Dreamweavn