Consecutive date range on consecutive worksheets
 

How can I add consecutive dates on multiple worksheets? I am trying to
create a workbook for each month of the year with all days include. Is there
a way to input the dates all at once or do I just have to go through each
worksheet and input the date manually?

Consecutive date range on consecutive worksheets
 

Something like this should work for you:
=SUM(Sheet1:Sheet3!A1)

Just type in the function, click the cell that you will base your
calculation on, and hold down the Shift key, select the last sheet in the
range that your calculations will include, and hit enter.


Regards,
Ryan--


--
RyGuy


"john3478" wrote:

How can I add consecutive dates on multiple worksheets? I am trying to
create a workbook for each month of the year with all days include. Is there
a way to input the dates all at once or do I just have to go through each
worksheet and input the date manually?

I need to be able to add consercutive dates on multiplesheet
 

I need to be able to add consercutive dates on multiple sheets on excel.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

I need to be able to add consercutive dates on multiple sheet
 

Sub Date_Increment()
''increment a date in A1 across sheets
Dim myDate As Date
Dim iCtr As Long
myDate = DateSerial(2007, 7, 1) 'adjust to suit
For iCtr = 1 To Worksheets.Count
With Worksheets(iCtr).Range("A1")
.Value = myDate - 1 + iCtr
.NumberFormat = "mm-dd-yyyy"
End With
Next iCtr
End Sub


Gord Dibben MS Excel MVP

On Wed, 14 Jan 2009 02:46:16 -0800, Caroline Masenya wrote:

I need to be able to add consercutive dates on multiple sheets on excel.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng