If I have a list of dates, how can I choose the beg or ending date within this range?
E Excel User Sep 21, 2005 #1 If I have a list of dates, how can I choose the beg or ending date within this range?
W William Horton Sep 21, 2005 #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
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
