Page 624 - Excel 2013 All-in-One For Dummies

606 Filtering Data
✦ Between: Opens the Custom AutoFilter dialog box with the Is After or Equal To operator selected in the first condition and the Is Before or Equal To operator selected in the second AND condition.
✦ Tomorrow: Filters the data list so that only records with tomorrow’s date in this field are displayed in the worksheet.
✦ Today: Filters the data list so that only records with the current date in this field are displayed in the worksheet.
✦ Yesterday: Filters the data list so that only records with yesterday’s date in this field are displayed in the worksheet.
✦ Next Week: Filters the data list so that only records with date entries in the week ahead in this field are displayed in the worksheet.
✦ This Week: Filters the data list so that only records with date entries in the current week in this field are displayed in the worksheet.
✦ Last Week: Filters the data list so that only records with date entries in the previous week in this field are displayed in the worksheet.
✦ Next Month: Filters the data list so that only records with date entries in the month ahead in this field are displayed in the worksheet.
✦ This Month: Filters the data list so that only records with date entries in the current month in this field are displayed in the worksheet.
✦ Last Month: Filters the data list so that only records with date entries in the previous month in this field are displayed in the worksheet.
✦ Next Quarter: Filters the data list so that only records with date entries in the three-month quarterly period ahead in this field are displayed in the worksheet.
✦ This Quarter: Filters the data list so that only records with date entries in the current three-month quarterly period in this field are displayed in the worksheet.
✦ Last Quarter: Filters the data list so that only records with date entries in the previous three-month quarterly period in this field are displayed in the worksheet.
✦ Next Year: Filters the data list so that only records with date entries in the calendar year ahead in this field are displayed in the worksheet.
✦ This Year: Filters the data list so that only records with date entries in the current calendar year in this field are displayed in the worksheet.
✦ Last Year: Filters the data list so that only records with date entries in the previous calendar year in this field are displayed in the worksheet.
✦ Year to Date: Filters the data list so that only records with date entries in the current year up to the current date in this field are displayed in the worksheet.