|
Auto Fill Options
How do you change the auto fill options from weekly dates to fortnightly dates
-- Dorothy Berry |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com