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