Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |