View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default determining & returning least and greatest dates

Hi DJS

for the greatest = max(a2:a10)
for the least = min(a2:a10)

hth
regards from Brazil
Marcelo

"DJS" escreveu:

I have a coulumn with dates:

DT
28-Jun-06
05-Jul-06
26-Jun-06
03-Jul-06
23-Jun-06
26-Jun-06
05-Jul-06

Is it possible to write a func which will return the leasst and greatest
dates from the column?