Compare date value to current date in Google Sheets

Question

How can I compare the date in a row to a current date, so that if it's greater than today the next steps in my process need to be executed?

Answer 1

Short answer

Assuming that you want to compare a date in the cell A1 with the current date, use the following formula:

=A1>TODAY()

The above will return TRUE if the value of the cell A1 is the greater than the current date.

Explanation

In Google Sheets the comparison functions and operators could be used with dates if they are properly formatted.

By properly formatted, I mean that spreadsheet engine is able to interpret the cell value as a date. For Google Sheets a date is a serialized number that has assigned a date format. One alternative among others to check if a value is a number is to use ISNUMBER.

Comparison functions:

• EQ Equivalent to the = operator.
• GT Equivalent to the > operator.
• GTE Equivalent to the >= operator.
• LT Equivalent to the < operator.
• LTE Equivalent to the <= operator.