What formula adds 1 day to date in another workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Reference the cell that has the 'last date' in and add 1 to it.

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

Mike

NikiB said:
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?
Click to expand...
Click to expand...
 
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 said:
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 said:
Reference the cell that has the 'last date' in and add 1 to it.

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

Mike

NikiB said:
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?
Click to expand...
Click to expand...
Click to expand...
 
brill - just what I need - thanks again

Mike H said:
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 said:
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 said:
Reference the cell that has the 'last date' in and add 1 to it.

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

Mike

:

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top