Need some help with auto-fill

  • Thread starter Thread starter Per Carlsson
  • Start date Start date
P

Per Carlsson

Im trying to get autofill to fill dates in batches of ten after each
other, but with little success.
like so...
Is there anyone who can help me with this?

2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-01
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-02
2009-01-03
 
With your starting date in A1 formatted how you would like, put this
formula in A2:

=IF(COUNTIF(A$1:A1,A1)<10,0,1)+A1

and then copy it down as far as you need to.

Hope this helps.

Pete
 

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

Subtotal by 2 different criteria 1
COUNT 2
Date lists 3
Count based on date criteria 1
Concatenating two variable fields into a static length text field 2
Conditional Format Font Color for more than 3 conditions 3
Sumproduct? 1
Simultaneous calls 4

Back
Top