Need some help with auto-fill

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
 
P

Pete_UK

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
 
Top