'Declaration Public Enum FormatConditionTimePeriod Inherits System.Enum
public enum FormatConditionTimePeriod : System.Enum
| Member | Description |
|---|---|
| LastMonth | The cell's date/time value is compared to the month before the current one. |
| LastSevenDays | The cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the System.Globalization.CalendarWeekRule. |
| LastWeek | The cell's date/time value is compared to the week before the current one, as defined by the System.Globalization.CalendarWeekRule. |
| NextMonth | The cell's date/time value is compared to the month after the current one. |
| NextWeek | The cell's date/time value is compared to the week after the current one, as defined by the System.Globalization.CalendarWeekRule. |
| ThisMonth | The cell's date/time value is compared to the current month. |
| ThisWeek | The cell's date/time value is compared to the current week, as defined by the System.Globalization.CalendarWeekRule. |
| Today | The cell's date/time value is compared to the current date. |
| Tomorrow | The cell's date/time value is compared to the day after the current date. |
| Yesterday | The cell's date/time value is compared to the day before the current date. |
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2