The cell's date/time value is compared to the month before the current one.
The cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the CalendarWeekRule.
The cell's date/time value is compared to the week before the current one, as defined by the CalendarWeekRule.
The cell's date/time value is compared to the month after the current one.
The cell's date/time value is compared to the week after the current one, as defined by the CalendarWeekRule.
The cell's date/time value is compared to the current month.
The cell's date/time value is compared to the current week, as defined by the CalendarWeekRule.
The cell's date/time value is compared to the current date.
The cell's date/time value is compared to the day after the current date.
The cell's date/time value is compared to the day before the current date.
Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat.