| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
