date format YYYY-MM-DD fill handle excel 2007

i have data in the format YYYY-MM-DD  (a custom date format). When I try to create further dates in sequence using the fill handle, for example creating values 2009-06-30 to 2009-07-01 the auto fill handle sequencing does not work as it produces 2009-06-31,2009-06-32 etc...

any suggestions?
Who is Participating?
cyberkiwiConnect With a Mentor Commented:
What you have is actually TEXT that looks like a date and to you represents a date.
Enter in a fresh cell somewhere the date "6/30/2009" without quotes.
Use cell formatting to change the DISPLAY format to yyyy-mm-dd.
Now use the fill handle - it will behave correctly.
Bordeaux0113Connect With a Mentor Commented:
Click format, cells, number tab, click date and select the type you want.
Then it should work just fine :)
gerrymac1943Author Commented:
great thanks
No problem Good luck :)
All Courses

From novice to tech pro — start learning today.