Auto Fill Options

  • Thread starter Thread starter Dorothy
  • Start date Start date
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
 
What I mean by fortnightly dates is:

example: 4/1/02 then 18/1/02 then 1/2/02 and so on
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
auto-fill options button 2
How do I get the Fortnight number of the year from a date? 1
auto fill options (copy cell, not create series) 4
Rotate data by date 1
Date and If problem 6
Date Auto Fill 3
Change Default Auto-Fill-In month 4

Back
Top