How do I find....

S

Smitch

Hey,
I have a coulmn with a heap of dates in the format of dd/mm/yyyy. I
want to find the earliest and the latest date in the list then
calculate the number of days that lie between them.

NB: not all the cells within the coumn will have a date, some cells
will be blank.

How do i do this?

Thanks Heaps
Smitch
 
S

Smitch

ok, well i thought that prob was more complecated than it actually was.
Heres another qestion:

I have two colums, one contains a bunch of random dates in the form of
dd/mm/yyyy.
The 2nd column has a number next to each date.
I want to go down the columns and sum the number in the 2nd column for
each month. So i will end up with 12 totals, for each month.

Any tips?

Thanks in advance
Smitch
 
D

Don Guillett

how about. The ranges must be the same size
=sumproduct((month(daterng)=2)*sumrange)
or
=sumproduct((month(a2:a22)=2)*b2:b22)
 
Top