• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

how to find a weekly date range in excel

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
1 Solution
ES-ComponentsAuthor Commented:
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

You could use a helper' column to filter your data

with this formula


Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now