L Lynn Oct 10, 2009 #1 I have a series of dates. How can i filter dates that are within this week? thanks
L Lars-Åke Aspelin Oct 10, 2009 #2 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
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
