Thanks so much, tigeravatar! Actually, this didn't work out for my particular data set. I don't have any spaces in between the dates in my rows, so my set goes straight from 12/8/09 to 12/11/09 without any break.
But this did inspire me. In a separate sheet, I used your first command, but then I simplified the second one to
=B2+1
in date format. Then I copied this down and just merged my two tables.
Wonderful! Thanks so much for your speedy guidance.
Bookmarks