This documentation is archived and is not being maintained.

XlDynamicFilterCriteria Enumeration

Specifies the filter criterion.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlDynamicFilterCriteria

Member nameDescription
xlFilterTodayFilter all values related to the current date.
xlFilterYesterdayFilter all values related to yesterday.
xlFilterTomorrowFilter all values related to tomorrow.
xlFilterThisWeekFilter all values related to the current week.
xlFilterLastWeekFilter all values related to last week.
xlFilterNextWeekFilter all values related to next week.
xlFilterThisMonthFilter all values related to the current month.
xlFilterLastMonthFilter all values related to last month.
xlFilterNextMonthFilter all values related to next month.
xlFilterThisQuarterFilter all values related to the current quarter.
xlFilterLastQuarterFilter all values related to last quarter.
xlFilterNextQuarterFilter all values related to next quarter.
xlFilterThisYearFilter all values related to the current year.
xlFilterLastYearFilter all values related to last year.
xlFilterNextYearFilter all values related to next year.
xlFilterYearToDateFilter all values from today until a year ago.
xlFilterAllDatesInPeriodQuarter1Filter all dates in Quarter1.
xlFilterAllDatesInPeriodQuarter2Filter all dates in Quarter2.
xlFilterAllDatesInPeriodQuarter3Filter all dates in Quarter3.
xlFilterAllDatesInPeriodQuarter4Filter all dates in Quarter4.
xlFilterAllDatesInPeriodJanuaryFilter all dates in January.
xlFilterAllDatesInPeriodFebrurayFilter all dates in February.
xlFilterAllDatesInPeriodMarchFilter all dates in March.
xlFilterAllDatesInPeriodAprilFilter all dates in April.
xlFilterAllDatesInPeriodMayFilter all dates in May.
xlFilterAllDatesInPeriodJuneFilter all dates in June.
xlFilterAllDatesInPeriodJulyFilter all dates in July.
xlFilterAllDatesInPeriodAugustFilter all dates in August.
xlFilterAllDatesInPeriodSeptemberFilter all dates in September.
xlFilterAllDatesInPeriodOctoberFilter all dates in October.
xlFilterAllDatesInPeriodNovemberFilter all dates in November.
xlFilterAllDatesInPeriodDecemberFilter all dates in December.
xlFilterAboveAverageFilter all above-average values.
xlFilterBelowAverageFilter all below-average values.
Show: