I'm creating a worksheet that will be an at-a-glance calendar for a large
group of people. I want to have a row separating the events for each week
that says "Week of May 30, 2005" and I want to be able to auto-fill in 7-day
increments. Anyone know of a way to do this?

Thanks!

If you separate the 'week of' part from the date, i.e. in a different column,
you can enter the first two dates in your sequence in the format 30/05/2005
or similar, then if you select those two dates and drag the fill handle it
will auto fill with the same increment. You can then format those dates as
you wish them to appear.
Hope this helps.

Tara

"SavvySam" wrote:

I'm creating a worksheet that will be an at-a-glance calendar for a large
group of people. I want to have a row separating the events for each week
that says "Week of May 30, 2005" and I want to be able to auto-fill in 7-day
increments. Anyone know of a way to do this?

Thanks!

It was tricky, but I found another way to do it. In the advice content I
found something that allows you to use formulas on text and numerical
(combined) entries. So I had a formula that looked like this:

A
1 Data
2 Billing Date
3 5-Jun-2007

Formula Description
="Statement date: "&TEXT(A3, "d-mmm-yyyy")

(Result)
Combine text in a formula with a date (Statement date: 5-Jun-2007)

Then all I had to do was set up the column to the right with the dates
increasing at 7 day increments.

Thanks for the reply!



"Tarah" wrote:

If you separate the 'week of' part from the date, i.e. in a different column,
you can enter the first two dates in your sequence in the format 30/05/2005
or similar, then if you select those two dates and drag the fill handle it
will auto fill with the same increment. You can then format those dates as
you wish them to appear.
Hope this helps.

Tara

"SavvySam" wrote:

I'm creating a worksheet that will be an at-a-glance calendar for a large
group of people. I want to have a row separating the events for each week
that says "Week of May 30, 2005" and I want to be able to auto-fill in 7-day
increments. Anyone know of a way to do this?

Thanks!