Sum Dates

[SFrick]

I have a spreadsheet with 8 years worth of data in col months. For
example row5 Col's C through CF have dates starting with the first day
of the month, like 01 Jan 04. Row6 Col's C through CF have dates
ending with the last day of each month, like 31 Jan 04.

Rows 8 through 80 have data associated with each month.

What I want to be able to do is enter a start date and end date and
from those dates have all the data betwenn those dates sum in col B

Thanks for all help

 

[Bill]

If Cell A1 is 1/1/04 and Cell A2 is 1/31/04, in Cell A3 put the formula
"=A2-A1" and set the cell formatting to be a "Number". That is all there is
to subtracting dates. Excel will think it is a date and enter a result of
something like "1/31/1900" because all of Excel's date calculations are
based on the Julian Calendar starting from 1/1/1900. With that cell
selected, click "Format", "Cells", and on the "Number" TAB change the
default "Date" to "Number".

Hope this helps!

Bill Foley
www.pttinc.com

 

[Don Guillett]

try this. All ONE LINE
=SUM(INDIRECT(CHAR(MATCH($B$1,$C$1:$E$1,0)+2+64)&"3:"&CHAR(MATCH($B$2,$C$2:$
E$2,0)+2+64)&"1000"))

 

[SFrick]

Thanks for the help.

Here is a combined formula that help solve the problem:

=SUM(INDIRECT(CHAR(MATCH($B$1,$C$1:$X$1,0)+2+64)&ROW()&":"&CHAR(MATCH($B$2,$C$2:$X$2,0)+2+64)&ROW()))