- Select a column containing dates.
- In the Functions panel, type Compare Dates and click the result to open the options for the associated function.
- In the Compare mode list, choose the comparison mode.
You can compare the column with another column or with a given date.
The dates contained in the selected column are compared, either with a date you entered or with dates contained in another column. The result of the comparison is written in a new column, true when the condition is matched, false when the condition is not.