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.

public enum TimePeriodType


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.

See Also