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


--
Smitch
------------------------------------------------------------------------
Smitch's Profile: http://www.excelforum.com/member.php...o&userid=28821
View this thread: http://www.excelforum.com/showthread...hreadid=485730

Have a look at MIN and MAX in help index

--
Don Guillett
SalesAid Software

"Smitch" wrote in
message ...

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


--
Smitch
------------------------------------------------------------------------
Smitch's Profile:
http://www.excelforum.com/member.php...o&userid=28821
View this thread: http://www.excelforum.com/showthread...hreadid=485730

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


--
Smitch
------------------------------------------------------------------------
Smitch's Profile: http://www.excelforum.com/member.php...o&userid=28821
View this thread: http://www.excelforum.com/showthread...hreadid=485730

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

--
Don Guillett
SalesAid Software

"Smitch" wrote in
message ...

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


--
Smitch
------------------------------------------------------------------------
Smitch's Profile:
http://www.excelforum.com/member.php...o&userid=28821
View this thread: http://www.excelforum.com/showthread...hreadid=485730