filtering dates within this week

  • Thread starter Thread starter Lynn
  • Start date Start date
I have a series of dates. How can i filter dates that are within this
week?

thanks
Click to expand...

Assuming your dates are in column C and that weeks start on Mondays ,
try this formula in cell D1:

=C1-TODAY()+WEEKDAY(TODAY(),3)<7

Copy down as far as needed.

This will yield TRUE in column D for the rows where the corresponding
dates in column C are within this week.

Hope this helps / Lars-Åke
 

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

date filtering by number 2
Pivot table macro filter data between yesterday and today (date+time) 0
Macro to filter on most current date. 5
current week, current month, current year 1
Extracting the Time from a Date/Time Stamp 2
Split 9 weeks of data on a worksheet into 9 separate worksheets 1
Limit Dates in Pivot Table 1
group filtering 2

Back
Top