determining & returning least and greatest dates
 

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?

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?

determining & returning least and greatest dates
 

Thanks Marcelo!
I guess I was expecting it to be more complicated than that :)

"Marcelo" wrote:

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?

determining & returning least and greatest dates
 

glad to help
tks for the feedback
Marcelo

"DJS" escreveu:

Thanks Marcelo!
I guess I was expecting it to be more complicated than that :)

"Marcelo" wrote:

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?