Thread
:
How do I find....
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
How do I find....
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
Reply With Quote