TimePeriodType
TimePeriodType enumeration
Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.
Values
Name | Value | Description |
---|---|---|
Today | 0 | Today’s date. |
Yesterday | 1 | Yesterday’s date. |
Tomorrow | 2 | Tomorrow’s date. |
Last7Days | 3 | A date in the last seven days. |
ThisMonth | 4 | A date occurring in this calendar month. |
LastMonth | 5 | A date occurring in the last calendar month. |
NextMonth | 6 | A date occurring in the next calendar month. |
ThisWeek | 7 | A date occurring this week. |
LastWeek | 8 | A date occurring last week. |
NextWeek | 9 | A date occurring next week. |
ThisYear | 10 | A date occurring this year. Only for .ods. |
LastYear | 11 | A date occurring last year. Only for .ods. |
NextYear | 12 | A date occurring next year. Only for .ods. |