Click or drag to resize

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.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (20.10)
public enum TimePeriodType
  Member nameValueDescription
Today0 Today's date.
Yesterday1 Yesterday's date.
Tomorrow2 Tomorrow's date.
Last7Days3 A date in the last seven days.
ThisMonth4 A date occurring in this calendar month.
LastMonth5 A date occurring in the last calendar month.
NextMonth6 A date occurring in the next calendar month.
ThisWeek7 A date occurring this week.
LastWeek8 A date occurring last week.
NextWeek9 A date occurring next week.
ThisYear10 A date occurring this year. Only for .ods.
LastYear11 A date occurring last year. Only for .ods.
NextYear12 A date occurring next year. Only for .ods.
See Also