View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] moochito@invalid.hotmail.com is offline
external usenet poster
 
Posts: 5
Default Is there a way to create dates 7 days apart automatically?

On Thu, 22 Dec 2005 09:57:25 -0500, "Gary Keramidas"
<GKeramidasATmsn.com wrote:

not sure what you want to accomplish.
put 1/1/06 in a1, 1/8/06 in b1, select both cells, click and drag the box in
the lower right corner of b1 (mouse pointer changed to a +) as far across
as you want to go.



Hiya,

I'm trying to create a timesheet for myself.

1/1/06 - 1/8/06
1/9/06 - 1/16/06
|
|
|
|
|
|

And ending at:
December 31, 2006. (or there abouts.)

I don't know if it's possible, but I'd love for Excel to fill in the
blanks so I don't have to.

Thanks in advance.