The Beginning Date would be =MIN(A1:A10)
The Ending Date would be =MAX(A1:A10)
Where A1:A10 is your range of dates. Enter the above formulas in some cells
and it should give you your answer. You may have to format the cells with a
date format.
Hope this helps.
Thanks,
Bill Horton
"Excel User" wrote:
If I have a list of dates, how can I choose the beg or ending date within
this range?
|