| 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 | |||
Linear Mode
