incremental increase across worksheets within a workbook

G'day,

I have created a workbook that contains a seperate worksheet for everyday of the month that will be used as a template to create a seperate workbook for every month of the year.

The workbook contains a homepage with hyperlinks to all the worksheets that the workbook contains.

The homepage is also where the month and year are entered into specific cells which are then used as refernce for all the other worksheets (ie if I put July 2004 in the allocated cells on the homepage then all the other worksheets show July 2004)

I believe there is a way to also include on the homepage the name of the first day of the month (eg Thursday for July 2004) and then for the worksheets to incrementally increase by one day (eg 2/7/04 = Friday, 3/7/04 = Saturday... 31/7/04 = Saturday) and so on...

But i can not work out how to do it and can only find instructions for series etc on the same worksheet...

Can any one please help me?

Thanks in anticipation!

ANZAC

ANZAC,

Excel is notoriously bad at the 3-D functions that would allow you to do
this easily. For a one time set up, simply go to each sheet and put an
incremented number in each sheet's cell A1. Then in the first sheet, put
the Month number in A2, and the year in A3. Then group all the other
sheets, and in cell A2, type an = sign, then select the first sheet, then
cell A2, and press Enter. Do the same for A3. Then group all the sheets,
and enter the the DATE function in one cell:

=DATE(A3,A2,A1)

Since the sheets are grouped, the formula will appear on all sheets,
appropriately referencing the cells on each sheet.

HTH,
Bernie
MS Excel MVP


"ANZAC" wrote in message
...
G'day,

I have created a workbook that contains a seperate worksheet for everyday
of the month that will be used as a template to create a seperate workbook
for every month of the year.

The workbook contains a homepage with hyperlinks to all the worksheets
that the workbook contains.

The homepage is also where the month and year are entered into specific
cells which are then used as refernce for all the other worksheets (ie if I
put July 2004 in the allocated cells on the homepage then all the other
worksheets show July 2004)

I believe there is a way to also include on the homepage the name of the
first day of the month (eg Thursday for July 2004) and then for the
worksheets to incrementally increase by one day (eg 2/7/04 = Friday, 3/7/04
= Saturday... 31/7/04 = Saturday) and so on...

But i can not work out how to do it and can only find instructions for
series etc on the same worksheet...

Can any one please help me?

Thanks in anticipation!

ANZAC

G'day Bernie,

Thanks for the reply.

That is roughly what i did for the date.

But how would i do similiar to get an invcremental increase of Days ie Monday, Tuesday... .... & Sunday?

Thanks again.
ANZAC

"Bernie Deitrick" wrote:

ANZAC,

Excel is notoriously bad at the 3-D functions that would allow you to do
this easily. For a one time set up, simply go to each sheet and put an
incremented number in each sheet's cell A1. Then in the first sheet, put
the Month number in A2, and the year in A3. Then group all the other
sheets, and in cell A2, type an = sign, then select the first sheet, then
cell A2, and press Enter. Do the same for A3. Then group all the sheets,
and enter the the DATE function in one cell:

=DATE(A3,A2,A1)

Since the sheets are grouped, the formula will appear on all sheets,
appropriately referencing the cells on each sheet.

HTH,
Bernie
MS Excel MVP


"ANZAC" wrote in message
...
G'day,

I have created a workbook that contains a seperate worksheet for everyday
of the month that will be used as a template to create a seperate workbook
for every month of the year.

The workbook contains a homepage with hyperlinks to all the worksheets
that the workbook contains.

The homepage is also where the month and year are entered into specific
cells which are then used as refernce for all the other worksheets (ie if I
put July 2004 in the allocated cells on the homepage then all the other
worksheets show July 2004)

I believe there is a way to also include on the homepage the name of the
first day of the month (eg Thursday for July 2004) and then for the
worksheets to incrementally increase by one day (eg 2/7/04 = Friday, 3/7/04
= Saturday... 31/7/04 = Saturday) and so on...

But i can not work out how to do it and can only find instructions for
series etc on the same worksheet...

Can any one please help me?

Thanks in anticipation!

ANZAC

ANZAC,

You can easily convert the dates to Days by using a reference to your date
cell (say, =D4), and then formatting for custom "dddd" (without the
quotes).

HTH,
Bernie
MS Excel MVP

"ANZAC" wrote in message
news
G'day Bernie,

Thanks for the reply.

That is roughly what i did for the date.

But how would i do similiar to get an invcremental increase of Days ie
Monday, Tuesday... .... & Sunday?

Thanks again.
ANZAC

"Bernie Deitrick" wrote:

ANZAC,

Excel is notoriously bad at the 3-D functions that would allow you to do
this easily. For a one time set up, simply go to each sheet and put an
incremented number in each sheet's cell A1. Then in the first sheet,
put
the Month number in A2, and the year in A3. Then group all the other
sheets, and in cell A2, type an = sign, then select the first sheet,
then
cell A2, and press Enter. Do the same for A3. Then group all the
sheets,
and enter the the DATE function in one cell:

=DATE(A3,A2,A1)

Since the sheets are grouped, the formula will appear on all sheets,
appropriately referencing the cells on each sheet.

HTH,
Bernie
MS Excel MVP


"ANZAC" wrote in message
...
G'day,

I have created a workbook that contains a seperate worksheet for
everyday
of the month that will be used as a template to create a seperate
workbook
for every month of the year.

The workbook contains a homepage with hyperlinks to all the worksheets
that the workbook contains.

The homepage is also where the month and year are entered into
specific
cells which are then used as refernce for all the other worksheets (ie
if I
put July 2004 in the allocated cells on the homepage then all the other
worksheets show July 2004)

I believe there is a way to also include on the homepage the name of
the
first day of the month (eg Thursday for July 2004) and then for the
worksheets to incrementally increase by one day (eg 2/7/04 = Friday,
3/7/04
= Saturday... 31/7/04 = Saturday) and so on...

But i can not work out how to do it and can only find instructions for
series etc on the same worksheet...

Can any one please help me?

Thanks in anticipation!

ANZAC

Bernie,
Thanks for your time and help... it works a treat and i have learned something new!
ANZAC

"Bernie Deitrick" wrote:

ANZAC,

You can easily convert the dates to Days by using a reference to your date
cell (say, =D4), and then formatting for custom "dddd" (without the
quotes).

HTH,
Bernie
MS Excel MVP

"ANZAC" wrote in message
news
G'day Bernie,

Thanks for the reply.

That is roughly what i did for the date.

But how would i do similiar to get an invcremental increase of Days ie
Monday, Tuesday... .... & Sunday?

Thanks again.
ANZAC

"Bernie Deitrick" wrote:

ANZAC,

Excel is notoriously bad at the 3-D functions that would allow you to do
this easily. For a one time set up, simply go to each sheet and put an
incremented number in each sheet's cell A1. Then in the first sheet,
put
the Month number in A2, and the year in A3. Then group all the other
sheets, and in cell A2, type an = sign, then select the first sheet,
then
cell A2, and press Enter. Do the same for A3. Then group all the
sheets,
and enter the the DATE function in one cell:

=DATE(A3,A2,A1)

Since the sheets are grouped, the formula will appear on all sheets,
appropriately referencing the cells on each sheet.

HTH,
Bernie
MS Excel MVP


"ANZAC" wrote in message
...
G'day,

I have created a workbook that contains a seperate worksheet for
everyday
of the month that will be used as a template to create a seperate
workbook
for every month of the year.

The workbook contains a homepage with hyperlinks to all the worksheets
that the workbook contains.

The homepage is also where the month and year are entered into
specific
cells which are then used as refernce for all the other worksheets (ie
if I
put July 2004 in the allocated cells on the homepage then all the other
worksheets show July 2004)

I believe there is a way to also include on the homepage the name of
the
first day of the month (eg Thursday for July 2004) and then for the
worksheets to incrementally increase by one day (eg 2/7/04 = Friday,
3/7/04
= Saturday... 31/7/04 = Saturday) and so on...

But i can not work out how to do it and can only find instructions for
series etc on the same worksheet...

Can any one please help me?

Thanks in anticipation!

ANZAC