Thread: What formula adds 1 day to date in another workbook?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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?
Reply With QuoteReply With Quote