Insert Row after every week?

[nbaj2k]

I have a column of dates (all weekdays). I want to know how I would go about inserting a row after every week. An example is shown below. (Consider the spaces to be inserted rows. Everytime a weeks dates are over I wanted a row to be inserted, and then for it to do this continuously until it finds the last cell with a date. All of the dates are in column A.

Thanks,

~J

9/1/2006

9/4/2006
9/5/2006
9/6/2006
9/7/2006
9/8/2006

9/11/2006
9/12/2006

[stevebriz]

Try this:

Please Login or Register  to view this content.