<div>
I forgot to mention that I need to display the current week only no matter what day the current day is. So if I click a button it will find the current weeks order no matter if today is 12/21/12or 8/28/13.<br />
Thank you<br />
Rick
</div>


I forgot to mention that I need to display the current week only no matter what day the current day is. So if I click a button it will find the current weeks order no matter if today is 12/21/12or 8/28/13.
Thank you
Rick

CurrWeek.xlsx

<div>
<div class="content wysiwyg-content">
I have orders with a shipdate. Order is in A1 and shipdate is in B1 in two rows. The dates are not in any order. I need to display the orders by week. Is there a formula that will list the orders by week Monday thru Sunday?<br />
Thank you<br />
Rick
</div>
</div>


I have orders with a shipdate. Order is in A1 and shipdate is in B1 in two rows. The dates are not in any order. I need to display the orders by week. Is there a formula that will list the orders by week Monday thru Sunday?
Thank you
Rick

how to find a weekly date range in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.