determining & returning least and greatest dates

G

Guest

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?
 
G

Guest

Hi DJS

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

hth
regards from Brazil
Marcelo

"DJS" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Product Problem 4
Counting dates in a column 4
formula to calculate the average of a range basing on condition 4
Filtering dates using a formula 5
Any notification through Excel Spreadsheet 5
how to set range in excel 1
Auto Fill Series of Dates & Times 3
Formula help required please 10

Top