Skip to main content

Conditional Formatting: Advanced Date Comparisons

Conditional formatting has been enhanced with more flexible date comparisons. New comparison operators such as "Is earlier than N days from today" and "Is later than N days from today" are now available.

This allows you, for example, to highlight tasks whose due date falls within the next 14 calendar days, or to mark projects whose start date is more than 30 days in the past. It also enables you to visually represent sprint periods or upcoming deadlines.

note

Values are specified in calendar days. All comparisons are based on the current date ("today") and automatically shift as time progresses.

Advanced date comparisons in conditional formats

Help article: Conditional Formats