View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ferrero[_2_] Ed Ferrero[_2_] is offline
external usenet poster
 
Posts: 99
Default How can I autofill dates having a blank cell between each day?

Hi Dee,

Enter a date in cell A1 (eg 5/13/08), enter the next day's date in cell A3
(eg 5/14/08).

Select cells A1 trough to A4 (ie select two dates and two blank cells).

See the little dot at the bottom right of the selection rectangle? Click on
that (the cursor will change to a cross when you are over the right spot)
and drag it down as far as you want.

Ed Ferrero
www.edferrero.com