Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I choose a date from list with an agrument?
If I have a list of dates, how can I choose the beg or ending date within
this range? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update master list with other lists | Excel Worksheet Functions | |||
How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
Latest date from multiple list | Excel Worksheet Functions | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
How can I sum information in a list with a date range? | Excel Worksheet Functions |