XlFilterAllDatesInPeriod Enumeration
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

XlFilterAllDatesInPeriod Enumeration

Office 2007
Specifies how dates should be filtered in the specified period.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlFilterAllDatesInPeriodDay2Filter all dates for the specified date.
xlFilterAllDatesInPeriodHour3Filter all dates for the specified hour.
xlFilterAllDatesInPeriodMinute4Filter all dates until the specified minute.
xlFilterAllDatesInPeriodMonth1Filter all dates for the specified month.
xlFilterAllDatesInPeriodSecond5Filter all dates until the specified second.
xlFilterAllDatesInPeriodYear0Filter all dates for the specified year.


Show:
© 2016 Microsoft