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

On Apr 30, 4:52*pm, Per Carlsson
wrote:
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