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