If a date is greater than

How to test if a date is greater than another date and return a value if the test is True or False through the use of an Excel formula, with the IF function

Excel

If a date is greater than using IF function

EXCEL FORMULA 1. If a date is greater than

EXCEL

Hard coded formula

Cell reference formula

=IF(B8>$C$5,"Greater","Lower")

=IF(B10>$C$5,$C$6,$C$7)

GENERIC FORMULA

=IF(date>greater_date,value_if_true,value_if_false)

ARGUMENTS
date: A date that you want to test against another date to identify if it's greater than this date.
greater_date: A date that another date is tested against.
value_if_true: Value to be returned if the date is greater than the greater_date.
value_if_false: Value to be returned if the date is not greater than the greater_date.

GENERIC FORMULA

=IF(date>greater_date,value_if_true,value_if_false)

EXPLANATION

This formula uses the IF function to test if a date is greater than another date and return a value if the test is True or False.

Click on either the Hard Coded or Cell Reference button to view the formula that has the return values directly entered into the formula or referenced to a specific cell.

In this example the formula identifies if a date is greater than another date through the use of the greater than (>) sign. Out of the three dates that we are testing two of them are greater than the specific date and therefore the formula will return a text value of "Greater". For the date that is less than or equal to the specific date the formula will return a text value of "Lower".