What formula adds 1 day to date in another workbook?
 

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?

What formula adds 1 day to date in another 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?

What formula adds 1 day to date in another 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?

What formula adds 1 day to date in another 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?

What formula adds 1 day to date in another 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?