XlTimePeriods Enumeration
Specifies the time period.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlLast7Days | 2 | Last 7 days |
| xlLastMonth | 5 | Last month |
| xlLastWeek | 4 | Last week |
| xlNextMonth | 8 | Next month |
| xlNextWeek | 7 | Next week |
| xlThisMonth | 9 | This month |
| xlThisWeek | 3 | This week |
| xlToday | 0 | Today |
| xlTomorrow | 6 | Tomorrow |
| xlYesterday | 1 | Yesterday |