| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Options
How do you change the auto fill options from weekly dates to fortnightly dates
-- Dorothy Berry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Fill Options
What do you mean by 'fortnightly dates'?
You can add 15 to the date you have and copy down to get dates spaced every 15 days... Or Edit-Fill-Series and give Step as 15 "Dorothy" wrote: How do you change the auto fill options from weekly dates to fortnightly dates -- Dorothy Berry |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Fill Options
What I mean by fortnightly dates is:
example: 4/1/02 then 18/1/02 then 1/2/02 and so on -- Dorothy Berry "Sheeloo" wrote: What do you mean by 'fortnightly dates'? You can add 15 to the date you have and copy down to get dates spaced every 15 days... Or Edit-Fill-Series and give Step as 15 "Dorothy" wrote: How do you change the auto fill options from weekly dates to fortnightly dates -- Dorothy Berry |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Fill Options
Then as mentioned below
Enter 4/1/02 in A1 Select the range you want to fill down to Edit-Fill-Series and give Step as 14 "Dorothy" wrote: What I mean by fortnightly dates is: example: 4/1/02 then 18/1/02 then 1/2/02 and so on -- Dorothy Berry "Sheeloo" wrote: What do you mean by 'fortnightly dates'? You can add 15 to the date you have and copy down to get dates spaced every 15 days... Or Edit-Fill-Series and give Step as 15 "Dorothy" wrote: How do you change the auto fill options from weekly dates to fortnightly dates -- Dorothy Berry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto-fill options button | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| auto fill options | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Hybrid Mode
