|If you don't want to auto-fill the dates everytime - e.g. if you are changing the first date on a regular basis, you can use a simple formula:|
If your date is in A1, enter =A1+1 in A2 and then drag that down as far as you will need it.
Since Excel stores dates as numbers, with each integer being 1 day and fractions thereof being the time, adding 1 to a date adds 1 day.
Day 1 in most Excel installations is 1/1/1900
Currently, 12/2/2010 9:45:35 AM EST, it's Day 40514.4066550926
Posting Tip: Before posting Data or VBA Code, read this How-To.