Excel: Best way to create new row for every day of month 1

[Xaqte]

I have a worksheet where I input data into a new row for every day for a given month. For each row, I input today's date in column A & various other statistical data in following columns. I need a way to create a new row for every day for one month in one instance, rather than manually typing/inserting the rows. I was thinking of having a field to select month and year & upon selection it would do the row creations. However, I'm pretty new with this and would appreciate any thoughts/experience on how to do this or a better way to do this.

Thanks,
X

 

[SkipVought]

X,

Why not Previous Date + 1?

So if your date column were A and A1 contained 4/1/2005, then...
[tt]
A2: =A1+1
[/t]

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[SkipVought]

Oh and...

every row after that is just copied and pasted into the next.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[Xaqte]

Skipvought, that is a great idea! However, something I failed to specify (or mention) correctly was this is for business days and not weekends. Given this fact, this would make it more difficult because different months have different amounts of workdays at different intervals. But thanks again for the quick response! Got any other brainstorms?

X

 

[SkipVought]

[tt]
=A1+IF(MOD(A1+1,7)=0,3,1)
[/tt]


Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[Xaqte]

SkipVought, that is simply beautiful! I would love for you to break down what this is doing (if ya have the time). I'm going to be working with this quite a bit over the next couple of days & will post back if I discovered something else I failed to mention/specify.

Thanks again!

X

 

[SkipVought]

Do you understand the MOD function?

MOD returns the REMAINDER of one number divided by another; in this case a DATE (which is just a number in MS applications) and 7.

So a Saturday date divided by 7, will always have a remainder of 0 (in Microsoft applications). So in that case I add 3 days, otherwise add 1 day to the previous date.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[Xaqte]

Again, much thanks for your quick response and breaking it down SkipVought! It makes alot more since now!

X