Expand Minimize

XlFilterAllDatesInPeriod Enumeration

Specifies how dates should be filtered in the specified period.

Version Added: Excel 2007

Name

Value

Description

xlFilterAllDatesInPeriodDay

2

Filter all dates for the specified date.

xlFilterAllDatesInPeriodHour

3

Filter all dates for the specified hour.

xlFilterAllDatesInPeriodMinute

4

Filter all dates until the specified minute.

xlFilterAllDatesInPeriodMonth

1

Filter all dates for the specified month.

xlFilterAllDatesInPeriodSecond

5

Filter all dates until the specified second.

xlFilterAllDatesInPeriodYear

0

Filter all dates for the specified year.

Community Additions

ADD
Show:
© 2014 Microsoft