filtering dates within this week
 

I have a series of dates. How can i filter dates that are within this
week?

thanks

filtering dates within this week
 

On Fri, 9 Oct 2009 18:49:35 -0700 (PDT), Lynn
wrote:

I have a series of dates. How can i filter dates that are within this
week?

thanks

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