How can I choose a date from list with an agrument?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a list of dates, how can I choose the beg or ending date within
this range?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Agrument or if/and statement 6
Complex date VBA - insert a certain weekday 5
#Name? Error when using NETWORKDAYS function ...... 2
IFs with VLOOKUPs 5
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Which CPU I should choose for coding and multitasking? 0
Sorting day names chronologically 5

Back
Top