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 |