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!
|