In the List Range control, enter A5:E13.In the Sort & Filter group, click Advanced Filter.Now you’re ready to apply the advanced filter: Then, enter the following criteria expression into both D2 and E2: =WEEKNUM(TODAY()) Next, copy the header cells to create a criteria range (A1:E1). As you can see, the week numbers for the start and end dates aren’t always the same for each record sometimes the time period extends beyond the current week. Similarly, the function in column E returns the week number for each end date. The WEEKNUM() function in column D returns the week number for each start date. Then, copy the functions to the remaining cells in each column. To adjust this simple data set for a more advanced filter, add two helper columns based on the following functions in cells D6 and E6, respectively: =WEEKNUM(B6) =WEEKNUM(C6) For instance, the function WEEKNUM(“”) returns the value 26. This simple function uses the following form to return the week number: WEEKNUM( datetext) There are probably a half dozen ways to accomplish this task, but I recommend two helper columns and the WEEKNUM() function. Now, let’s suppose that you need to display only those records where both the start and end date fall within the current week. To clear the filter, simply click Clear in the Sort & Filter group. As you might expect, you could apply the same filter to the EndDate column and get a different result (or not, depending on the date values). They’re convenient and easy to use-even for users with limited skills. You probably noticed that there are a number of date filters. Before, the filtered records reflect a current day of Jthrough June 30, 2012. The filtered group displays only those records where the StartDate value falls within the current week. Then, choose This Week from the resulting submenu.Click the StartDate column’s dropdown filter and choose Date Filters.Next, apply a simple filter by clicking the Data tab and then clicking Filter in the Sort & Filter group.First, select the entire data range by clicking in any cell in the data range and pressing ++8.
To illustrate the simple filter, let’s find all the records where the start date falls within the current week, as follows: Neither choice is wrong it just depends on your needs. Your first hurdle is to decide whether you’re filtering by the start or end date. The simple data set shown below comprises two date columns, a start and an end date. (Neither of these techniques work in Excel 2003.) Simple filter By current, we mean a Sunday through Saturday week. In this post, we’ll review a simple filter for dates falling within the current week. If you’re using Excel 2007 or 2010, you’re in luck, because there are several built-in date filters. If you’re using Excel to schedule events for any projects, chances are you filter those records by specific criteria. When they're not, try helper columns and date functions. Use Excel 20's built-it date filters when they're adequate.
#Insert current date in excel 2010 how to
How to filter an Excel 20 data set for the current week