3

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?

migrated from superuser.com Jun 20 '16 at 2:47

This question came from our site for computer enthusiasts and power users.

4

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.