I have a spreadsheet which details each day for each week in a workbook. For
each new workbook (or each new week), what formula do I use in the 1st cell
of the 2nd workbook (week) to contunie the date from the last day in the 1st
workbook?

Reference the cell that has the 'last date' in and add 1 to it.

=[Book1.xls]Sheet1!$A$1+1

Mike

"NikiB" wrote:

I have a spreadsheet which details each day for each week in a workbook. For
each new workbook (or each new week), what formula do I use in the 1st cell
of the 2nd workbook (week) to contunie the date from the last day in the 1st
workbook?

Great, thanks Mike - this works a treat but I still need to drag this cell so
that I can increment the dates for the 2nd week (and 3rd week etc)

What I ideally want to do, is input the 1st date in the 1st cell on the 1st
workbook and the remaining 4 (or 5 depending on how many weeks in the month)
workbooks are updated accordingly

"Mike H" wrote:

Reference the cell that has the 'last date' in and add 1 to it.

=[Book1.xls]Sheet1!$A$1+1

Mike

"NikiB" wrote:

I have a spreadsheet which details each day for each week in a workbook. For
each new workbook (or each new week), what formula do I use in the 1st cell
of the 2nd workbook (week) to contunie the date from the last day in the 1st
workbook?

If you want to create a date in (say) book 2 when you enter a date in book1
then you have to resort to VBA.

If you want to reference a date already entered in another workbook and have
it dragable then you could use:-

=[Book1.xls]Sheet1!$A$1+ROW(A1)

The above formula will add 1 day to the date for every cell it's dragged down.

Mike

"NikiB" wrote:

Great, thanks Mike - this works a treat but I still need to drag this cell so
that I can increment the dates for the 2nd week (and 3rd week etc)

What I ideally want to do, is input the 1st date in the 1st cell on the 1st
workbook and the remaining 4 (or 5 depending on how many weeks in the month)
workbooks are updated accordingly

"Mike H" wrote:

Reference the cell that has the 'last date' in and add 1 to it.

=[Book1.xls]Sheet1!$A$1+1

Mike

"NikiB" wrote:

I have a spreadsheet which details each day for each week in a workbook. For
each new workbook (or each new week), what formula do I use in the 1st cell
of the 2nd workbook (week) to contunie the date from the last day in the 1st
workbook?

brill - just what I need - thanks again

"Mike H" wrote:

If you want to create a date in (say) book 2 when you enter a date in book1
then you have to resort to VBA.

If you want to reference a date already entered in another workbook and have
it dragable then you could use:-

=[Book1.xls]Sheet1!$A$1+ROW(A1)

The above formula will add 1 day to the date for every cell it's dragged down.

Mike

"NikiB" wrote:

Great, thanks Mike - this works a treat but I still need to drag this cell so
that I can increment the dates for the 2nd week (and 3rd week etc)

What I ideally want to do, is input the 1st date in the 1st cell on the 1st
workbook and the remaining 4 (or 5 depending on how many weeks in the month)
workbooks are updated accordingly

"Mike H" wrote:

Reference the cell that has the 'last date' in and add 1 to it.

=[Book1.xls]Sheet1!$A$1+1

Mike

"NikiB" wrote:

I have a spreadsheet which details each day for each week in a workbook. For
each new workbook (or each new week), what formula do I use in the 1st cell
of the 2nd workbook (week) to contunie the date from the last day in the 1st
workbook?