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

NameValueDescription
Today0Today’s date.
Yesterday1Yesterday’s date.
Tomorrow2Tomorrow’s date.
Last7Days3A date in the last seven days.
ThisMonth4A date occurring in this calendar month.
LastMonth5A date occurring in the last calendar month.
NextMonth6A date occurring in the next calendar month.
ThisWeek7A date occurring this week.
LastWeek8A date occurring last week.
NextWeek9A date occurring next week.
ThisYear10A date occurring this year. Only for .ods.
LastYear11A date occurring last year. Only for .ods.
NextYear12A date occurring next year. Only for .ods.