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: (19.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 occuring in this calendar month.
LastMonth5 A date occuring in the last calendar month.
NextMonth6 A date occuring in the next calendar month.
ThisWeek7 A date occuring this week.
LastWeek8 A date occuring last week.
NextWeek9 A date occuring next week.
See Also