ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I choose a date from list with an agrument? (https://www.excelbanter.com/excel-worksheet-functions/46567-how-can-i-choose-date-list-agrument.html)

Excel User

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?

William Horton

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?



All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com