XlTimePeriods enumeration (Excel)
Specifies the time period.
| 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 |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.